Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Incorrect Auto-total of Measure

Hi all, I have a file that combined accrued numbers (from SQL) and verified numbers (entered manually into excel and linked). 

I created a measure that pulls the accrued total for a time period if the verified has not yet been entered: 

=if(Verified=0, calculate(sum(Accrued), Verified) 

The data appears correct in the table view but the auto total ignores the rows which are using the accrued value. 

E.g. 

Q1 Verified = 100
Q2 Verified = 100
Q3 No Verified, so pulls Accrued = 100 

Auto-total appears = 200 rather than 300. 

Is there a reason it wouldnt recognize the Q3's 100? 

Thanks in advance

Need Help

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    We can try to create such a measure to meet your requirement.

     

    measure =
SUMX ( 'Table', IF ( [Verified] = 0, [Accrued], [Verified] ) )

     

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ DongLi
    If this post helps, then please consider Accept it as the solution to help the other members find it more

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you but this doesn't work due to the complicated nature of my tables. It's really disappointing that Power BI isn't smart enough to just add the values in the table. Tableau does it