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_IDNow 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
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 =
SUM ('FACT_Sell-through'[Sell-through] ),
TREATAS ( VALUES ( Dim_Outlets[Compare_Outlet_ID] ), Dim_Outlets[Outlet_ID] )
CurrentSellThrough - CompareSellThrough
View solution in original post
@tamerj1 worked! Thx a lot!
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
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!