topic Re: Aggregating data across rows in DAX Commands and Tips

Aggregating data across rows

Anonymous — Thu, 31 Dec 2020 14:57:14 GMT

Re: Aggregating data across rows

littlemojopuppy — Wed, 30 Dec 2020 16:00:39 GMT

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]) ) )

Re: Aggregating data across rows

Anonymous — Thu, 31 Dec 2020 07:36:09 GMT

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.

Re: Aggregating data across rows

mahoneypat — Thu, 31 Dec 2020 14:16:47 GMT

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

Re: Aggregating data across rows

littlemojopuppy — Thu, 31 Dec 2020 14:31:16 GMT

Anonymous so in place of the SUM([Value]) insert the name of the measure