Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
Moehimby's avatar
Moehimby
Icon for Helper III rankHelper III
1 year ago

This is absolutely ridiculous and Microsoft really needs to fix this.

NotebookEnjoyer's avatar
NotebookEnjoyer
Icon for Advocate II rankAdvocate II
10 months ago

It really isn't. If you have some row-wise calculation before summing up (which is the only case in which this behavior appears), DAX can't just guess for you the granularity on which you want this calculation applied.

This is explained well here: No more measure totals shenanigans