Incorrect Measure Total

[lcasey]

Hello,

I am struggling with understanding why measures do not total correctly.

In this report ,  I am trying to perform the following calculation while keeping the filter context on the table.

IF the Invoice Age is equal to or less than 6,  then calculate the reserve * Current Exchange rate otherwise 0.

LTTPEXCHANGE =

SUMX (

    VALUES ( '000_BadDebt'[Document Number] ),IF([AGE] <=6,

MAX('000_BadDebt'[Reserve]) * MAX('00-Bad_Debt_MC'[XCHGRATE]),0))

Then I simply want to show the reserve needed:  IF the document is <=6 then LTTPEXCHANGE else     [Revalued NET Commision (USD)]

Reserve Needed = SUMX('000_BadDebt',IF(

    [AGE] <=6,

    [LTTPEXCHANGE],

    [Revalued NET Commision (USD)]

    ))

However,  the actual row to row calculation works just great, but the actual total does not.

How can I get the calculation to work?

Thank

[v-jiascu-msft]

Hi @lcasey,

What's wrong with the total?

Can you share a sample?

What does "the document is <=6" mean?

Best Regards,

Dale