Forum Discussion
Incorrect Grand total value
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
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
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.