Forum Discussion
Trying to get average from this table
Hi, this table is from PowerBI and the Grand Total at the bottom is the average of this set of data by month. I can't seem to create a measure that duplicates the value that's in each month in the a...
Anonymous that's the question, what measure you are using to change the color?
That's the challenge.
In February you can see that the average in that column is 78.0 but the average of the entire table is 77.7
So when I apply the font to the column, it thinks that the average is 77.7
What I'm trying to do is use 78.0 as the median to determine if a column is above or below the average, but it keeps referring to 77.7. Because I'm having trouble creating a measure that looks at each columns average, not the average of the entire table.hI, Was the information provided to you, helpful regarding the challenge? Do you need additional information from me?