Calculation showing as NULL

Question

Hi All,
In my cube I have 2 measures which are count distinct. I created a calculation (Measure1-Measure2), when the values of Measures are equal instead of showing the difference as 0 (ZERO) , my calculation is showing it as NULL in the browser. I have tried different formats and none did not work. Please advice.
Thanks

Answer 1

Hi @Amy Jandreau ,

Are you using SSAS Tabular or SSAS Multidimensional?

If you are using Tabular, you may try add 0 in your measure to display 0, something like Mymeasure = Mymeasure+0

If you are using SSAS Multidimensional, you may need to use IIF to display the value you want, IIF(Measure1=Measure2, "0", Measure1=Measure2)

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@ZoeHui-MSFT and @Darren Gosbell Thanks that worked.