Forum Discussion
Measure in line chart problem
I have a hospital finance data set including the financial information (like net income etc.) for each hospital from 2011 to 2019. I am now creaing a line chart to show the net income by year for the...
Hey Denis
Measure 2 = CALCULATE(AVERAGE('Benchmark-v5 $'[value]), ALLEXCEPT('Benchmark-v5 $' [attribution]), This is the formula I used for the measure. I unpivot the orginal data into "attribution" and "value", the value contains all the exact number and attribution contain all the category like net income, revenue and so on.
Thanks!
Hi wuzimuzyqtt ,
Could you pls provide some sample data with expected output for test?
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!