Dividing 2 Measures

[maj]

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:  https://drive.google.com/file/d/1vD8uMDx3YvVtRFUkGwAXFW-bo67PO0RM/view?usp=sharing 

Thank you.

-maj

[V-pazhen-msft]

@maj 
You may first try add the Week field to the measure 3 visual. 

Could you share a sample pbix, some test is required for us to figure it out.

Regards 
Paul

[maj]

Here is the link to a PBIX sample file:

https://drive.google.com/file/d/13Gvuv0wi7h9epAPpsu47nJnx8PTeQhJZ/view?usp=sharing

Perhaps my measure 3 isn't working as expected because in one query the product is ITEM-SKU-CDTY-DESC and in the other query it's ITEM-SCN-CDTY-DESC?

[harshnathani]

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)

[maj]

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

Again, here is link to sample PBIX file.  Any help would be greatly appreciated!!

https://drive.google.com/file/d/1ZflGIDmIhR6zQEjqeo-UKwx9XKiHx4RP/view?usp=sharing

Thank you,

-maj