topic Re: Compare Sell-through of 2 Stores within one Table-Visual in DAX Commands and Tips

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

Knast — Thu, 04 Aug 2022 08:18:36 GMT

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

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

daXtreme — Thu, 04 Aug 2022 08:15:22 GMT

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.

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

Knast — Thu, 04 Aug 2022 08:19:21 GMT

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

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

tamerj1 — Thu, 04 Aug 2022 08:46:30 GMT

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

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

Knast — Thu, 04 Aug 2022 09:31:15 GMT

tamerj1 worked! Thx a lot!