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

  • 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.