Forum Discussion

btwilkins's avatar
btwilkins
Frequent Visitor
6 years ago
Solved

SUMX calculated Total different from Aggregation

I'm sure this is a really simple issue that I am completely missing but when I am calculating a column total based on two variables;

Sector "WCB"

RSP Period "20/09"

 

XXPTL TOTAL =
CALCULATE (
    SUMX ( 'Fct SG PTL ODP Period', 'Fct SG PTL ODP Period'[xx PTL ODP] )
)
 
 
I Get
 
Rsp Period Sector XXPTL TOTAL XX PTL ODP(Aggregation)
20/09 WCB 3.56 3.25
 
WTF!!??
 
Help please - Do I have some error in the cube?
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi btwilkins ,

     

    Since I don’t know the formula of the measure  'XX PTL ODP ', I can’t find the cause of the error, you can try to do so.

    XXPTL TOTAL = 
IF(
    HASONEVALUE('Fct SG PTL ODP Period'[Sector]),
    'Fct SG PTL ODP Period'[xx PTL ODP],
    SUMX( ALL('Fct SG PTL ODP Period'), 'Fct SG PTL ODP Period'[xx PTL ODP])
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

8 Replies