Measure in line chart problem

[wuzimuzyqtt]

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 selected hospital, and I want to add the average netincome for all the hospital by year into the chart. I am trying to use a measure average(net income) but when I add this into the chart it gives me a horizental line.. how can I make this average net income change by year in the chart? 

Thanks for any advice!

PS:

There are 5 columns in the data, Hospital ID, Hospital Name, Year, Attribution, Value

Where the Attribution include different benchmark name like Net income, Operating revenue etc. and the Value column shows the exact number for the corresponding attribution.

[wuzimuzyqtt]

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!

[v-kelly-msft]

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!

[selimovd]

Hey @wuzimuzyqtt ,

can you post the formula of the measure?

Best regards

Denis