Forum Discussion

nick9one1's avatar
nick9one1
Helper III
2 years ago
Solved

Help with a measure

I have a quite basic table of Audit results and I'm trying to put it in a matrix to display results across the year. 

 

The value of (first)Score is obviously just taking the first score from the whole table (below)


How would I use a measure to show the relevant score for the row (auditee)?

Thank you



Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi nick9one1 ,

    I create a table as you mentioned.

    Then I create a measure and here is the DAX code:

    Measure = 
SWITCH(
    TRUE(),
    MAX('T1'[Score]) > 50, "Green",
    MAX('T1'[Score]) <= 50, "Red"
)

    What I think is that you can add the measure into the matrix visual and it will achieve your requirement.

     

     

     

    Best Regards

    Yilong Zhou

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

2 Replies

  • nick9one1's avatar
    nick9one1
    Helper III
    2 years ago

    If I create a lookupvalue column to get the row it seems to work, but doesnt show all the cleaners as only two have been audited so far.


    So I need to use the related 'legal full name' column from the userlist table. But doing that causes the problem in my first post.  

     




  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi nick9one1 ,

    I create a table as you mentioned.

    Then I create a measure and here is the DAX code:

    Measure = 
SWITCH(
    TRUE(),
    MAX('T1'[Score]) > 50, "Green",
    MAX('T1'[Score]) <= 50, "Red"
)

    What I think is that you can add the measure into the matrix visual and it will achieve your requirement.

     

     

     

    Best Regards

    Yilong Zhou

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