Forum Discussion
Cumulative Balance Name wise Total
I need result for cumulative balance as doesn't works its giving result as zero for DAX Formula, pls guide Basically take a highest sales value and cumulative balance as mentioned on below table. ...
Hi,
If it is a cumulative from largest Salest to small try this,1st. Create a measure with your sales total (it might be your measure[Sales] value already
Example:Measure = CALCULATE(SUM((File[Sales Total])))Then another measure as,
Cumulative Sum from Largest =VAR CurrentValue = [Measure]RETURNCALCULATE([Measure],FILTER(ALL(YourTable),[Measure] >= CurrentValue)
Bmejia
Super User
Super UserHi,
If it is a cumulative from largest Salest to small try this,
1st. Create a measure with your sales total (it might be your measure[Sales] value already
Example:
Measure = CALCULATE(SUM((File[Sales Total])))
Then another measure as,
Cumulative Sum from Largest =
VAR CurrentValue = [Measure]
RETURN
CALCULATE(
[Measure],
FILTER(ALL(YourTable),
[Measure] >= CurrentValue
)