Incorrect Auto-total of Measure

[mj1996]

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

[v-lid-msft]

Hi @mj1996 ,

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

[mj1996]

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