Incorrect Grand total value

[OSS]

Dear all

I have a problem with the grand total calculation. 

I have uploaded my pbix. I think this way is the easiest way to explain and understand my problem. I need to receive a correct grand total for 'POS amount' column.

https://we.tl/t-9syB81uTZs

Please help me with this issue. 

[jdbuchanan71 · Accepted solution]

First question, in 'Cards Mapping' it looks like there is a duplicate value.  Could this be causing some problem?

• [Full Acc. Def.] 87017AZNBE0700000001 is in there twice with a POS% of 0.253560889064541

For the total calc I would do the following:

First write a couple measures to make the last setp easier

TotalCardExp = sum( 'Cards YTD'[Total Card Exp] )
POS%measure = sum( 'Cards Mapping'[POS%] )

Then you can write a measure that will go through the 'FULL ACC' table and do your calc.

POSAmount = SUMX ( 'FULL ACC', [TotalCardExp] * [POS%measure] )

The problem you are seeing in your report is that Grand Totals are not the sum of all the numbers above, they are the measure calculated with no filters so it is giving you [Total Card Exp] * [POS%] -6,556,122.88 * 17.79 = -116,631,611.78

[OSS]

Thank you very much.

And another big thanks for dublicate value. It was a problem and I couldn't find the source 🙂

You solved my two problems with one post 🙂 Thank you again.