Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |