wrong column subtotals

[Anonymous]

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. 

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Create a new meaure like that should fix the issue.

new = sumx(your table, [Measure C])

[Anonymous]

Thank you for your reponse, but doesnt work. 

Kind regards,

Stefanie

[Greg_Deckler]

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

[Anonymous]

Hi Greg, 

Thank your for your answer. Works perfectly!! 

Thank you for your help. 

Kr, 

Stefanie