DAX Code

Hi Singh_Yoshi 

You want to create two new tables that contain just the model code:
Model Table 1 

Model 1

FJ11, FJ16,FJ7,FJ8,FJ15,FJ12

Model Table 2 

Model 2

FJ11, FJ16,FJ7,FJ8,FJ15,FJ12

These tables can be created using Enter Data or in the Query Editor duplicate your original table twice and delete the extra columns. When loaded DO NOT join these into your model.

Now put these columns in two seperate slicers set to single select, this will let your user choose the two to compare.

Now you can create measure or edit your existing measures to take this into account using the SELECTEDVALUE function. This returns the only item in the filtered column.

For example to return the MSRP for item 1:
Calculate(

               SelectedValue('Table 1'[MSRP]) --Use SUM if you are adding, SV to return a single value

               ,'Table 1'[Model Code] = SelectedValue('Mode Table 1'[Model 1])

)

--This replaces the existing Model Code with the one selected in slicer 1

Now repeat for the second slicer.

Hi Singh_Yoshi 

To implement this solution, follow these steps:

1. Create a SlicerTable to enable the selection of Mode Code.
2. Use the following formula to create the necessary measure:

    

   SelectedModel1 = SELECTEDVALUE(slicer1[Model code], "None")
   SelectedModel2 = SELECTEDVALUE(slicer2[Mode code], "None")
   
   

   MSRP_Difference =
   VAR Model1 = [SelectedModel1]
   VAR Model2 = [SelectedModel2]
   RETURN
   CALCULATE(SUM('Table'[MSRP]), 'Table'[Model code] = Model1)
   - CALCULATE(SUM('Table'[MSRP]), 'Table'[Model code] = Model2)
   
   

   I hope this solution is helpful! If it works for you, please consider accepting it as the solution, and a kudos is always appreciated.

    

    

    

   

Hi Singh_Yoshi ,

This depends on how you have your model, but if you want to have two slicers then you need to have two different tables with the products so that you can use it on the slicers then you need to do a measure similar to this:

Product Comparision =
var FirstProduct = SELECTEDVALUE(Table1[Product])
var SecondProduct = SELECTEDVALUE(Table2[Product])

Return
CALCULATE(SUM(Table[Value]), Table[Product] = FirstProduct) - CALCULATE(SUM(Table[Value]), Table[Product] = SecondProduct)

This is just a simple measure that does the difference between both values, be aware that the two tables need to be disconnected from the initial table, and if you select more than one product on the slicer this calculation will return an error.

Hi Singh_Yoshi ,

You should create slicerTable to select Mode Code. And then use below formula to create measure:

SelectedModel1 = SELECTEDVALUE(slicer1[Model code],"None")

SelectedModel2 = SELECTEDVALUE(slicer2[Mode code],"None")

MSRP_Difference =
VAR Model1 = [SelectedModel1]
VAR Model2 = [SelectedModel2]
RETURN
    CALCULATE ( SUM ( 'Table'[MSRP] ), 'Table'[Model code] = Model1 )
        - CALCULATE ( SUM ( 'Table'[MSRP] ), 'Table'[Model code] = Model2 )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.