Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |