DAX Running Total

DAX DAX Calculations
1

Runnig Total.pbix (28.4 KB)

Hello Community,

I would need some help to understand an issue I have while calculating a running total.
I prepared a file for a better understanding of my problem.
The goal is to rank the ‘‘value1’’ but only based on the ‘‘value2’’ that are missing.

To do so, I placed a filter on the visual for ‘‘value2 = empty’’ and prepared 3 measures and they act accordingly so far ( total, %total, rankx).

Where I have an issue is when I need to calculate the running total. I tried several options but I can not get the desired output.

If anyone could help me understand what I am missing here or recommend another approach (not sure if the filter placed on the visual is the best option here) it would be greatly appreciated.

Thanks to All,

CeRunnig Total.pbix (28.4 KB) Runnig Total.pbix (28.4 KB) dric

2

@Cedric,

Try this measure:

Cumulative Total = 
VAR vTable =
    ADDCOLUMNS (
        ALLSELECTED ( 'Table'[Code] ),
        "@Pct", [% Total],
        "@Rank", [RankX]
    )
VAR vRank = [RankX]
VAR vSum =
    SUMX ( vTable, IF ( [@Rank] <= vRank, [@Pct] ) )
VAR vResult =
    IF ( HASONEVALUE ( 'Table'[Code] ), vSum, 1 )
RETURN
    vResult

image
image985×424 127 KB

2 Likes
3

Thank you, this is perfect !
Cedric