Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

Anonymous what is your average measure? What is the expected output?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    The average measure is the average on the last line of the table. The data output is accurate and working, but when I attempt to use the cell elements option in design, to change color depending on the average, instead of using the average at the bottom of each month (ex. January 77.2), it's using the average of the entire table, 77.7