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.
Please suggest what can be done.
