Showing revenue at benchmark stores

[krzysztof]

I've created a metric for the semantic stores. Unfortunately, it doesn't work with a date filter
Sample pbx: https://drive.google.com/open?id=1L2b9YIReTt27xSTmoBU8NCzDAO8QsGxO 

My metric: 

Revenue Bench Store = 
VAR myStore = VALUES( Store_Benchmarking[StoreID_Bench] )
VAR Result = CALCULATE( [Revenue Measure] ; ALL(Sales) ; Sales[StoreID] IN myStore )
RETURN
Result

[v-kelly-msft · Accepted solution]

Hi @krzysztof ，

Try to modify your measure as below:

Revenue Bench Store = 
VAR myStore = VALUES( Store_Benchmarking[StoreID_Bench] )
VAR Result = CALCULATE( [Revenue Measure] , ALL(Sales),FITER('Sales', Sales[StoreID] IN myStore ))
RETURN
Result

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Mariusz]

Hi @krzysztof 

ALL( Sales ) is removing filters coming from date, you can use ALLEXCEPT( Sales, Date ) instead.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn