Showing converse at benchmark stores

DAX DAX Calculations
1

@Melissa helped me to create a metric showing sales after semantic stores. Thank you very much! Unfortunately I wanted to do the same with the conversion but I still don’t get it. I’m asking for help.

PBX: https://drive.google.com/open?id=1CLugGGniNkSFnC0Ef_KaUXpaV3zz9I1y

1
11035×624 44.1 KB

2

Hi @Harris,

You have to calculate the elements separately, that’s why measure branching is so effective and a best practice…

Conversion Bench Store v2 = 
VAR myStore = VALUES( Store_Benchmarking[StoreID_Bench] )
VAR myTransactions = 
    CALCULATE( [Tansaction Sales], ALL( transaction_Sales ), transaction_Sales[StoreID] IN myStore ) -
    CALCULATE( [Transaction Returns], ALL( transaction_returns ), transaction_returns[StoreID] IN myStore )
VAR myTraffic = CALCULATE( [Traffic Measure], ALL(Traffic), Traffic[StoreID] IN myStore ) 
RETURN

DIVIDE( myTransactions, myTraffic )

.
Please take the time to go through these courses, I’m confident it’ll all become more clear.

https://forum.enterprisedna.co/t/measure-branching-methodology/4900

https://forum.enterprisedna.co/t/why-calculate-is-important/4919

https://forum.enterprisedna.co/t/calculate-function/3265

.
Here’s your file. I hope this is helpful.
eDNA - Showing converse at benchmark stores.pbix (146.2 KB)

3

I’ve done almost the entire course Mastering Dax. Your metrics are not working properly. Can you see in your spare time?
1

4

@Harris,

The metrics are working fine it’s just a matter of what you want to calculate :wink:

So I gather you want to take the date selection into account, no worries:

Conversion Bench Store v2 = 
VAR myStore = VALUES( Store_Benchmarking[StoreID_Bench] )
VAR myTransactions = 
    CALCULATE( [Tansaction Sales], ALLSELECTED( transaction_Sales ), transaction_Sales[StoreID] IN myStore ) -
    CALCULATE( [Transaction Returns], ALLSELECTED( transaction_returns ), transaction_returns[StoreID] IN myStore )
VAR myTraffic = CALCULATE( [Traffic Measure], ALLSELECTED(Traffic), Traffic[StoreID] IN myStore ) 
RETURN

DIVIDE( myTransactions, myTraffic )

.

image
image741×450 14 KB

5

Hi @Harris, we’ve noticed that no response has been received from you since the 13th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!