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 ab...
General Comment
Need Help
Show and Tell
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