Forum Discussion
wrong column subtotals
Hi Power Bi users,
I have a little issue with the column subtotals for a pivot table i've made using following dax-formula:
'MeasureC = IF(ISBLANK(MeasureA), (blank() + 0), MeasureB)'. What I want to do is to sum up the values for each staff number for the consecutive six weeks of year 2020. The problem is that the total value isn't correct. Not all values get summed up.
Hi Anonymous ,
Create a new meaure like that should fix the issue.
new = sumx(your table, [Measure C])
4 Replies
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/547907Hi Anonymous ,
Create a new meaure like that should fix the issue.
new = sumx(your table, [Measure C])
