Forum Discussion

Singh_Yoshi's avatar
Singh_Yoshi
Helper I
1 year ago
Solved

DAX Code

I have a table Called Table1 and columns as, Model code, Items, MSRP, Cost. model Code has following values, FJ11, FJ16,FJ7,FJ8,FJ15,FJ12. Now the requirement is to compare one model with another mo...
Need Help
Show and Tell
  • Ray_Minds's avatar
    Ray_Minds
    1 year ago

    Hi Singh_Yoshi 

    If you want to compare models using two slicer then you need duplicate your table
    and then use below DAX measure

     

    Step 1 :Create Duplicate Table(Ex. Duplicate Table1 and name it Table2)
    Step 2 :Add two slicers based on Table1[Model Code] and another based on Table2[Model Code]
    Step 3 :Creating DAX Measures for Selected Models

    --Measure
    In Table1
    SelectedModel1 = SELECTEDVALUE('Table1'[Model Code])

     

    In Table2
    SelectedModel2 = SELECTEDVALUE('Table2'[Model Code])

     

    Step 4 : Comparison Measures
    MSRPComparison =
    VAR Model1 = [SelectedModel1]
    VAR Model2 = [SelectedModel2]
    RETURN
    IF (
        NOT (ISBLANK(Model1)) && NOT (ISBLANK(Model2)),
        CALCULATE (
            SUM('Table1'[MSRP]),
            'Table1'[Model Code] = Model1
        ) - 
        CALCULATE (
            SUM('Table2'[MSRP]),
            'Table2'[Model Code] = Model2
        ),
        BLANK()
    )

     

     

     

     


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

MFelix's avatar
MFelix
Super User
1 year ago

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.