Forum Discussion
Aggregating data across rows
4 Replies
- littlemojopuppy
Community Champion
You want to follow the running total DAX pattern. Your measure should look something like this...
CALCULATE( SUM([Value]), FILTER( ALL(Calendar], Calendar[Date] <= MAX(Calendar[Date]) ) )Hi littlemojopuppy ,
Thanks for the reply. As you can see in my shared link to pbix file, the value shown are calculated using measure. The name of the measure is "sales ltm". So because of this I'm not able to use SUM() function as it does not take measure value.
- littlemojopuppy
Anonymous so in place of the SUM([Value]) insert the name of the measure
- mahoneypat
Microsoft Employee
I looked at your pbix. It is similar but different from the pics you show. I wasn't able to match what you are showing, so it is hard to troubleshoot it. Also, there are so many columns. You definitely should unpivot these data and simplify your model to make your analysis/visualization easier.
Regards,
Pat
