Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have a matrix in powerBI report, we want to add an overall status measure for each column.
overallStatus = "red" for 19.07 if any red exists in column 19.07, else "yellow" if any yellow exists in column 19.07, else "green"
Is it possible to calculte the measure from the matrix directly?
The red, yellow and green are calculated by a status measure based on threshold in the original matrix. Because the threshold for each row is different, I have to hard code the thresholds in the DAX to get the overallStatus.
We are thinking of moving the thresholds to a table for easier maintainance, then the logic is to calculate whether the status measure is above its red thresholds for any row, then whether it's above yellow thresholds for any row. Is there any way to do it?
Could you give a little more information on how this is calculated? It is a little hard to figure out - is each column a measure? Or is this used as a column header in the matrix. Also, if you could say how the measure works, that would help. From how I read it, it sounds like the rows and columns should be switched, but maybe I do not have enough information.
I think using a numeric for red, yellow, green would help. You can still have the words, but create another measure with 1 = red ,yellow = 2, green = 3, this will help with more efficient calculations.
A total would need to iterate across all rows, something like this:
Total =
MINX(
ADDCOLUMNS(
VALUES('Table'[Column1]),"@Measure",[Measure])
,[@Measure]
)
Appreciate your Kudos
Connect with me!
Stay up to date on
Read my blogs on
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |