Forum Discussion

komaragiri's avatar
komaragiri
Frequent Visitor
1 year ago
Solved

Need Help with Matrix Visual - Variance calc

Here is my data file Resource Id Resource Name work date Hours flag data source 12345 John Doe electrical 1/1/2025 10 Building actual 12345 John Doe electrical 1/1/2025 20 ...
  • SamsonTruong's avatar
    1 year ago

    Hi komaragiri ,

    To achieve this matrix, we will create 3 measures. I've replicated your data in my environment.

    First we will create a measure for Planned using the following DAX:

    Planned = 
    CALCULATE(
        SUM(TestData[Hours]),
        TestData[data source] = "planned"
    )


    Then we will create a measure for Actual using the following DAX: 

    Actual = 
    CALCULATE(
        SUM(TestData[Hours]),
        TestData[data source] = "actual"
    )


    Finally we will create a third measure that calculates the variance between them using the following DAX:

    Variance = 
    [Planned] - [Actual]



    Once the meaures are created, we can leverage them in a Matrix like so:

     

    If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

    Thanks,

    Samson