Benchmark between custom stores selection

[JohnnyDax]

Hi everyone,

I'm trying to make something like this work :

Benchmark Store - KPI = CALCULATE([KPI],filter(Store,UNION(Store,dim_benchmark_store)))

"Store" is my main store dimension with relationship to the data

"dim_benchmark_store" is a mirror of the "Store" table but with no relationship, it's purpose is to select store that will be compared to store selected in the "Store" dimension.

I'm doing something similar with date comparison, which is working but i guess because i'm helped by date function. And i'm trying to do the same through the store dimension.

I would try to avoid userelationship method since it's not performance friendly. Also i have several field in both store and benchmark store table i would like to be able to filter with any of them and not just one.

I don't know if this clear enough ? Thank you

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...