Forum Discussion

longtruong's avatar
longtruong
New Member
11 years ago
Solved

Incorrect SUM number?

Hello Everyone,   I have first tried PowerBI with a very simple query and got incorrect SUM number.     The correct total must be 373 instead of 318 in the above image.  I am not sure if Cou...
Need Help
  • Anonymous's avatar
    Anonymous
    11 years ago

    There will be a DAX formula that does it but I'm not exactly sure how (I'm new to DAX but not distinct count issues).

    At a guess investigating SUMX might be a good start, it should be possible to get that to sum the distinct count for each month.

     

    Here's a link to what looks like a similar technique:

     

    http://www.powerpivotpro.com/2010/02/sumx-the-5-point-palm-exploding-fxn-technique/

  • Tishchenko's avatar
    Tishchenko
    11 years ago

    Try create new key that combine SAPID and MonthID and then do DistinctCount on this new key field

longtruong's avatar
longtruong
New Member
11 years ago

Hello BarneyL,

 

Thanks for your response.  Is there any way to apply distinct count on month but count on total?

 

Regards,

 

Long

Anonymous's avatar
Anonymous
Not applicable
11 years ago

There will be a DAX formula that does it but I'm not exactly sure how (I'm new to DAX but not distinct count issues).

At a guess investigating SUMX might be a good start, it should be possible to get that to sum the distinct count for each month.

 

Here's a link to what looks like a similar technique:

 

http://www.powerpivotpro.com/2010/02/sumx-the-5-point-palm-exploding-fxn-technique/