How to create Sales difference between two products by Products selection in two slicers

[Kusaadigarla01]

Hi All,

My requirement is to show the sales difference of any two products by selecting products from two slicers (On single column).

I have data like below,

Product Name	Sales
Product1	2000
Product2	1500
Product3	1400
Product4	1450
Product5	1700
Product6	1800
Product7	2100
Product8	1750

I need to show two different slicers on same product name column like below.

Need to show Difference of two products which are selected in above slicers:

Thanks in advance.

Best regards,

Kusa

[barritown]

Hi @Kusaadigarla01,

I doubt there is a solution consisting of just one table and two slicers linked with the Product column. If I am wrong and someone proposes such a solution - I will be happy to watch and learn.

I think you will need an additional table. It could be either a full copy of your main table (one slicer should refer to Table1[Product], the other one to Table2[Product]) or a stand-alone table with all the values from the Product column.

In the first case your measure may look like:

Difference = MIN ( Table1[Sales] ) - MIN ( Table2[Sales] )

The second option will be a little bit more complicated - let me know if the first one doesn't fit your need for some reason.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian