cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Knast
Microsoft
Microsoft

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

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

Screenshot (56).png

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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

View solution in original post

4 REPLIES 4
tamerj1
Super User
Super User

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

@tamerj1 worked! Thx a lot!

daXtreme
Super User
Super User

@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.

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

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.