Forum Discussion
Dividing 2 Measures
Hello, I've created 2 measures that are used in 2 separate visuals. I want a 3rd visual that shows me measure 1 divided by measure 2. Please see document posted here for futher information: htt...
Hi maj ,
Yes, you are right. Because of this the values are not coming as expected.
When you pull 52 Week Consumption against ITM_SKU_CDTY_DESC, you can see how the values change.
This is thus giving you the wrong results.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
I created a relationship between product types in the 2 different tables and the calculation worked correctly. Now I'm trying to add in location so I can see the OOS% by product type, by location. Since I can't have 2 active relationships between the same 2 tables, I tried using the USERELATIONSHIP function, but I get the following error in my visual:
Error Message:
There are ambiguous paths between 'Sherlock Division Matrix' and 'OOS By Division': 'Sherlock Division Matrix'->'OOS By Division' and 'Sherlock Division Matrix'->'OOS By Division
There are ambiguous paths between 'Sherlock Division Matrix' and 'OOS By Division': 'Sherlock Division Matrix'->'OOS By Division' and 'Sherlock Division Matrix'->'OOS By Division
Again, here is link to sample PBIX file. Any help would be greatly appreciated!!
Thank you,
-maj