Forum Discussion

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Non-relationship values with +0

Hello everyone,   Does adding a +0 to a measure, break a relationship between 2 tables somehow?   So I have measure for complaints, and I have added +0 to it, in case there are no complaints,...
Need Help
Show and Tell
Tips and Tricks
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
3 years ago

Not a bug at all. It's concerned about a built-in mechanism called "empty-rows removal".

AutoExist and Normalization - SQLBI

 

One thing to remember, all things are considered filters in DAX. By default, you can't see those "unreasonable" rows only because the measure result are empty; those rows do exist! When +0 forced empty rows to 0; those "unreasonable" rows show up.

 

Solution to your issue is straightforward,

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hi CNENFRNL,

 

So I tried this solution and it works!

 

Just one thing, yes, the extra rows are not there anymore but, if the numerator and the denominator are both blank, then its still giving me a blank, even after adding the 0.

 

I tried putting in 0 as the default value, in the DIVIDE() funtion, but it didn't work.

 

Is there some way to fix this?

 

Thank you,

Vishesh Jain