Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please help.
Hi Visnhu, seems that Nation Flag relatioship with the table where TRx Raw belongs is one to more.
If you create a table with Nation Flag as dimension and Sum([Trx Raw]) as metric, how much is the sum row by row?
What is the primary key in Dim_geo? How does it relate to [Nation Flag]?
Hi Visnhu, seems that Nation Flag relatioship with the table where TRx Raw belongs is one to more.
If you create a table with Nation Flag as dimension and Sum([Trx Raw]) as metric, how much is the sum row by row?