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

Is waitTimeInSec itself a calculated measure? If so, what is the definition? I don't think the nulls are the problem here.

 

Chris

MSuser5's avatar
MSuser5
Helper III
2 years ago

Hi cpwebb ,

i have created measure in SSAS Cube level referring fact table column  (which is waitTimeInSec)

so the measure result while SUM appear wrongly as negative total. Is this because of NULL on that column?

 

MS