Grand Total is not correct

[Anonymous]

Hello,

I have this table:

As you can see, the grand total is not correct.

Here is the measure:

AnticipatedAdditionalPmnts = if([CYTotalGrossRevenue] * [PY%Pd] - [CYTotalPd]< 0 , 0, [CYTotalGrossRevenue] * [PY%Pd] - [CYTotalPd] )

Even if I can't get the grand total correct in the column, is there a way to capture the correct total in a measure?

[VahidDM]

Hi @Anonymous 

Please check this link:
https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[Anonymous]

Thank you so much @VahidDM . This sounds like it will work if I can figure out how to write the SUMMARIZE part of the measure.

The if statement uses measures, so I'm not sure what table and column I should use in the SUMMARIZE function. Again, here is my measure:

AnticipatedAdditionalPmnts = if([CYTotalGrossRevenue] * [PY%Pd] - [CYTotalPd]< 0 , 0, [CYTotalGrossRevenue] * [PY%Pd] - [CYTotalPd] )

[Anonymous]

@VahidDM , I tried this but it won't display the table now:

[VahidDM]

Hi @Anonymous 

In SUMX add only "[CYTotalGrossRevenue] * [PY%Pd] - [CYTotalPd]" then filter those less than 0.