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 |