Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It didn't seem to work for me.
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
Avg(If([Asset] = 'A', ([a] + [b] + [c])))