Forum Discussion

pritamdesh's avatar
pritamdesh
New Member
5 years ago
Solved

How to determine minimum value for a row in matrix visual

Hi Team, I want to display the minimum value of a row in the 'Total' column of a matrix visual. The Matrix is built as follows:   Rows  has 3 fields - Payor group name, Insurance company name, In...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try using this measure expression in place of your current one.  Don't delete the original as this one references it.

     

    New Measure = MINX(VALUES(Date[Year-Quarter]), [Average of Rate Allowed])

     

    You will get same values in the Year-Quarter columns as there is a single value there (always the min), but your total will be the min of all Year-Quarters.

     

    Pat

Drobb's avatar
Drobb
Frequent Visitor
2 years ago

I have a matrix visual in power bi that has the columns of a day of the week and shift, and the rows of week number.   

I am trying to return a logic statement where the minimum of each column and the maximum of each column shown in the visual (last 4 weeks) are taken into consideration. For example, if the color Flag number is 1 for each value for the last 4 weeks return -.025.  If the color Flag number is either 1 or 2 for each value in the last 4 weeks, return -0.02.  If the color flag number is 2 for each value the last for weeks return -0.015.  If the color flag number is either 2 or 3 for the last 4 weeks, return -.005, etc.  If none of the logic asks are satisfied return the word "Check". 

 

Can someone please advise how I can do this?

 

The values for the matrix are a measure if statement: 

Color Flag Number = IF([OTP]>.985,5,IF([OTP]>.965,4,IF([OTP]>.935,3,IF([OTP]>.915,2,1)))). 
OTP is a measure: 
OTP = DIVIDE(SUM(ontime[OnTime]),SUM(ontime[Total]))
Where the ontime values are columns.