Forum Discussion

Fali324's avatar
Fali324
Helper II
1 year ago
Solved

Comparing two states

Hi My data is structured in the following way: Project  Stage Cost A 1 10 A 2 20 B 1 10 B 2 40 B 3 30 C 1 10 For each project I want to compare the ...
  • Bibiano_Geraldo's avatar
    1 year ago

    HiFali324 ,

    You can achieve your goal bt these steps:

    1 - Create two tables for slicer 1 and slicer 2 by this DAX:

    Slicer 1 = VALUES(YourTable[Stage])
    Slicer 2 = VALUES(YourTable[Stage])

     

    2- Make sure tha they are NOT related:

     

    3 - Add a new slicer and add a project column from YourTable 

    4- Now add two slicer, in the first one, add the stages from the Slicer 1 Table and in the second Slicer add the Stages from the Slicer 2 Table

     

    Now add a measure to compare the cost value, in my case i'm just subtracting Slicer 1 - Slicer 2, feel free to adapt to attend your needs:

    Diference = 
    VAR totalSlicer1 = 
    CALCULATE(
        SUM(YourTable[Cost]),
        FILTER(
            YourTable,
            YourTable[Stage] = SELECTEDVALUE('Slicer 1'[Stage])
        )
    )
    
    VAR totalSlicer2 = 
    CALCULATE(
        SUM(YourTable[Cost]),
        FILTER(
            YourTable,
            YourTable[Stage] = SELECTEDVALUE('Slicer 2'[Stage])
        )
    )
    
    RETURN
    totalSlicer1 - totalSlicer2


    Add this Matrix for card or table, and your result will look like this: