MSuser5Helper III2 years agoSolvedMDX 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 : ...Show MoreMSuser5 to MSuser52 years agoThanks cpwebb , I have used SUM(coalesceEmpty([Measure].[waitTimeInSec],0)) and it's working fine.
MSuser5 to MSuser52 years agoThanks cpwebb , I have used SUM(coalesceEmpty([Measure].[waitTimeInSec],0)) and it's working fine.
MSuser5 to MSuser52 years agoThanks cpwebb , I have used SUM(coalesceEmpty([Measure].[waitTimeInSec],0)) and it's working fine.
MSuser5Helper III2 years agoHi cpwebb , Sure let me do deep analaysis on this issue and will share the details soon.Thanks for your prompt response. Regards,MS
MSuser5Helper III to MSuser52 years agoThanks cpwebb , I have used SUM(coalesceEmpty([Measure].[waitTimeInSec],0)) and it's working fine.
Related contentMDX QueryMDX to DAXExecuting MDX queries in a fabric notebook (via pyadomd or sempy)Trouble Writing MDX QueriesPassing parameters to MDX source queries
