Calculating average on a measure instead of a column
I have a table with multiple columns. Using few of the columns I have to calculate another column named 'Final Data'. I am doing this by a measure instead of adding a calculated column in the table. Further, I need to create a measure that calculates AVERAGEIF equivalent on 'Final Data' by applying various conditions and then plot on a chart.
As it turns out, the following expression gives me an error
Avg(If([Asset] = 'A', [Final Data])) where 'Asset' is the name of an actual column in my master table and ‘Final Data’ is the measure I used to create the column I needed.
This seems to only work for actual columns and not measures.
As a workaround, instead of creating a measure for 'Final Data', I just added the formula to calculate 'Final Data' in the expression that goes in the chart. Example of my final expression
