Forum Discussion
How to determine minimum value for a row in matrix visual
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
Microsoft EmployeePlease 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
It worked like a charm!! Thank you so much!! Kudos 🙂
