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
)
Hi - perfect DAX Formula, I need one more support the cumulative balance should work only v% column have value.
sample dataset:
Name Sales Total v% CUMbal Apple 55 24% 55 Orange 43 30% 98 Mango 33 131 Banana 22 22% 153 Papaya 12 80% 165 Total 165 output needs :
Name Sales Total v% CUMbal Apple 55 24% 55 Orange 43 30% 98 Banana 22 22% 120 Papaya 12 80% 132 Total 165