Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Create a new meaure like that should fix the issue.

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

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Create a new meaure like that should fix the issue.

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for your reponse, but doesnt work. 

 

Kind regards,

Stefanie