Compare Sell-through of 2 Stores within one Table-Visual

[Knast]

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

[tamerj1 · Accepted 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

[Knast]

@tamerj1 worked! Thx a lot!

[daXtreme]

@Knast 

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.

[Knast]

i added a link with example data - https://1drv.ms/u/s!AqT0loog1WXMjpFcbrKfGUo3WTQYkQ?e=QOtBHB