Can't make sense out of this! Please help

[vkish16161]

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.

[petter]

What is the primary key in Dim_geo? How does it relate to [Nation Flag]?

[rubenmarin · Accepted solution]

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?