Addition/Substraction operators problem in DAX measure

[Sergii24]

Hello everyone!

I'm creating a simple measure of following type: 

Measure1 = ( SUM(Table1[Column1]) / SUM(Table1[Column2]) ) + 2

As the result all matrix visuals (some columns from Table1 selected previosuly) become invisible expect the Measure,1 but the result of the measure is incorrect, it gives me 2 instead of adding this number to the result of SUM(Table1[Column1]) / SUM(Table1[Column2]).

The interesting part comes when I change the addition operator to multiplication/division operator. In this case it works perfectly and calculates the result correctly!

Any ideas why is it happen?

Thank you!

[Omega]

Please share an example and screenshot of the data 🙂

[Sergii24]

Hi!

Actually the issue has been resolved when I was preparing a test example for you, so thank you! 🙂

Still not sure what it was, but try to expain: there are 2 interconnected tables (relation many to one) and I had a product description in both. As soon as I used the description from the table that has only one line for each product the measure started to work properly. Instead, when I used the product description from the other table, where it repeated couple of times (same product, but different week or product location) the described in the problem issue repeated again and again. 

So, as a conclusion, I think it all happened because Power BI measure couldn't always correctly identify the row context.

[Omega · Accepted solution]

I always recommend to use codes or keys when creating relationships. Avoid using description as a key between the tables because they are tricky, the same description might be available in both tables but one might have an extra space at the end 🙂