Forum Discussion

MSuser5's avatar
MSuser5
Helper III
2 years ago
Solved

MDX Query

Hi Team,   I would like to calculate sum of value by excluding 'null' values in the column, I have tried in SSAS cube-new MDX as like below but the sum result is wrong instead of 9845  result is : ...
Need Help
  • MSuser5's avatar
    MSuser5
    2 years ago

    Thanks cpwebb ,

     

    I have used SUM(coalesceEmpty([Measure].[waitTimeInSec],0)) and it's working fine.

cpwebb's avatar
cpwebb
Microsoft Employee
2 years ago

Like I said, I don't think the nulls are the problem. You will need to provide a lot more detail on your cube design (please post screenshots of all relevant properties etc) in order to troubleshoot this.

MSuser5's avatar
MSuser5
Helper III
2 years ago

Hi cpwebb ,

 

Sure let me do deep analaysis on this issue and will share the details soon.

Thanks for your prompt response.

 

Regards,

MS

  • MSuser5's avatar
    MSuser5
    Helper III
    2 years ago

    Thanks cpwebb ,

     

    I have used SUM(coalesceEmpty([Measure].[waitTimeInSec],0)) and it's working fine.