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 there,
I want to compare the Sell-through of several stores with their counterparts within 1 Row of a Table visual.
I have DIM_Outles matched with FACT_Sell-through via Oultet_ID
Now a few of the Stores have a compare Store and I added the Info within the DIM_Outlets.
the "Focus Store comparison" is what I want to create.
Sample Data: https://1drv.ms/u/s!AqT0loog1WXMjpFcbrKfGUo3WTQYkQ?e=QOtBHB
Solved! Go to Solution.
Hi @Knast
Here is a sample file with the proposed solution https://www.dropbox.com/t/KkeqN6eamKqnpUvZ
VS. Compare Store =
VAR CurrentSellThrough =
SUM ( 'FACT_Sell-through'[Sell-through] )
VAR CompareSellThrough =
CALCULATE (
SUM ('FACT_Sell-through'[Sell-through] ),
TREATAS ( VALUES ( Dim_Outlets[Compare_Outlet_ID] ), Dim_Outlets[Outlet_ID] )
)
RETURN
CurrentSellThrough - CompareSellThrough
Hi @Knast
Here is a sample file with the proposed solution https://www.dropbox.com/t/KkeqN6eamKqnpUvZ
VS. Compare Store =
VAR CurrentSellThrough =
SUM ( 'FACT_Sell-through'[Sell-through] )
VAR CompareSellThrough =
CALCULATE (
SUM ('FACT_Sell-through'[Sell-through] ),
TREATAS ( VALUES ( Dim_Outlets[Compare_Outlet_ID] ), Dim_Outlets[Outlet_ID] )
)
RETURN
CurrentSellThrough - CompareSellThrough
Please supply some example data to work with. In text form, so that it's easy to copy. If you can share a file (via Dropbox or Google Drive, for instance) with such data, even better. Thanks.
i added a link with example data - https://1drv.ms/u/s!AqT0loog1WXMjpFcbrKfGUo3WTQYkQ?e=QOtBHB
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |