且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

DAX中的汇总金额

更新时间:2023-01-29 21:51:36

问题通过在度量中添加以下代码行来解决:

The issue was solved by adding following line of code to the measure:

Cumulative Quantity :=
    CALCULATE (
        SUM ( Transactions[Quantity] ),
        FILTER (
            ALL ( 'Date'[Date] ),
            'Date'[Date] <= MAX ( 'Date'[Date] )
        )
    )