Forum Discussion

naveenbabu's avatar
naveenbabu
Frequent Visitor
5 years ago

Matrix table not showing 0 for blank value

I have created a created two measures with below example,

 

frequency = distinctcount(column)+1

and tried 

frequency=if(isblank(distinctcount(column)),0,distinctcount(column))

but both of the above didnt work for me to display blank to 0. Please some one suggest any other way.

General Comment
Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    naveenbabu , Are you using a dimension/master table in this case. +0 usually forces a left join to show the value. If it from the same table(axis), it might not give the desired result.

     

    Check this option too

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi naveenbabu ,

     

    Does amitchandak ‘s solution help you? If yes, please accept it as the solution to help the other members find it more quickly.

    If the problem is not resolved, please provide a sample file containing the problem (remove sensitive data).

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.