Forum Discussion
Color Code matrix based on average value of Geos
Hi klehar,
Here is my solution:
My table:I added the "Order" column to sort the Geo as you have in your desired output.
In this table the Geo column is sorted by the olumn Order as you can see here:Measures I used:
Value Each Geo = MIN(T_DataGeo[Values]) -- To return each value that I have in the table. You need to adjust this measure according to your needs Avg KPY = CALCULATE( AVERAGE(T_DataGeo[Values]), ALLSELECTED(T_DataGeo[Geo], T_DataGeo[Order]) ) -- This measure returns the avegage to each KPY Color Measure = IF( [Value Each Geo] >= [Avg KPY], "GREEN", "RED" ) -- Return the colour according to the rules you mentioned
On the Cell elements apply a Background color for the measure "Value Each Geo":
Final Output:
_AAndrade Can this be also done when my column "KPI" is actually a measure and not a column
In my real data % completion looks like this :
% completition =
VAR numerator = calculate(...)
VAR denominator = calculate(...)
RETURN divide(numerator, denominator, 0)
Hi,
Yes it's possible to do it, by using that measure instead of my "Valeu each Geo" measure and computes the avg measure to compare one against other.
For the new AVG measure probably you will need to use summarize function, but it depends on your model.