This content has been marked as final. Show 2 replies
All attached is the pic for your reference. Basically
Sum(all [TRx Raw]) is returning 77 Million ( TRx Raw is in fact table)
Sum(Aggr(Sum([Trx Raw]), [Nation Flag] )) is returning 143 Million.
How can this be possible? When there's no duplication
Nation flag is coming from Geo Dim where there are 10 other fields. Nation Flag is not the primary key in Dim_geo.
For all the remaining fields in Dim Geo when I use a straight table and use Sum(TRx Raw) as a measure its coming out to 77 Million only.
Don't know why this is happening.