Forum Discussion
Odd table totaling behavior
Anonymous First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
Thanks for your reply, Greg.
I added a DATESBETWEEN filter to my m.OEEAvailability formula and that seems to have resolved my issue.
Do you know how DAX arrives at the totals it returns? My assumption is that PowerBI uses the underlying data to calculate the totals from scratch. I have some end-users that are worried that it is simply averaging the columns in the table visual to arrive at the totals.
- Greg_Deckler
Community Champion
Anonymous The default behavior is that the Total row calculates the DAX expression in the context of ALLSELECTED (or effectively ALL if no filters are being applied to the table)