2 Replies Latest reply: Jun 12, 2017 5:26 PM by Petter Skjolden RSS

    Can't make sense out of this! Please help

    Vishnu Chakrakishore

      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.