Forum Discussion
Odd table totaling behavior
I would like for the table totals to be averages of the values in their respective columns, but I can't find any place to adjust that setting. Currently, I have a table that is returning a total that is lower than any of the values in the column.
Is this determined by the measures fed into the tables?
The DAX behind the OEE column is:
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
3 Replies
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/n4TYhF2ARe8Thanks 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.
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)