Forum Discussion

mfattibello's avatar
mfattibello
Regular Visitor
8 years ago

Problems on implementing RunningSum measure using DAX

Dear,     I´m facing problems on implementing RunningSum measure using DAX. I have a rank measure showing the best revenues on a determined period and another dimension´s elements, according with ...
Need Help
Tutorial Requests
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi mfattibello,

 

Below is my test.

 

Sample dataset.

 

Create measures.

Ranking =
RANKX (
    ALLSELECTED ( Ranking[Category] ),
    CALCULATE ( SUM ( Ranking[Revenue] ) ),
    ,
    ASC,
    DENSE
)

Running sum =
VAR rankvalue = Ranking[Ranking]
RETURN
    CALCULATE (
        SUM ( Ranking[Revenue] ),
        FILTER ( ALLSELECTED ( Ranking[Category] ), Ranking[Ranking] <= rankvalue )
    )

Result.

 

Best regards,
Yuliana Gu