How to determine minimum value for a row in matrix visual

[pritamdesh]

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, Insurance plan name

Column has 1 field - Year- Quarter (values are for eg. 2020-Q1, 2020- Q2, etc)

Values has 1 field - A measure that calculates the Average of the rate field - [Average of rate allowed].

Average of rate allowed = AVERAGE('reporting vw_RateEstimator'[rate_allowed])

Can anybody help with the solution? Thanking in advance.

[Drobb]

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.  

[mahoneypat · Accepted solution]

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

[pritamdesh]

It worked like a charm!! Thank you so much!! Kudos 🙂