Line chart - line for total

[Donia12215]

I have line chart with % forecast variances for three programs and I would like to add % variance for all organisation. Forecast variances are measures based on forecasted values and actuals. Each programs have several units and I want to keep in dinamic. Below example is just to picture problem as I cannot publish actual companie's data. Do you think adding forecast variance line for all organisation is possible?

Forecast var = SUM('Fact data'[actual])-SUM('Fact data'[forecast])

Forecast var % = DIVIDE([Forecast var],SUM('Fact data'[forecast]))

[Donia12215 · Accepted solution]

I found solution by changing approach. Addidng it here as it might be helpfull. I created separate measures for each program and then created line chart with no legend but with four measures in values.

X Forecast var % = CALCULATE([Forecast var %], Programs[Program]="X")

Y Forecast var % = CALCULATE([Forecast var %], Programs[Program]="Y")

Z Forecast var % = CALCULATE([Forecast var %], Programs[Program]="Z")

Values in line chart:

Forecast var %

X Forecast var %

Y Forecast var %

Z Forecast var %

[amitchandak]

@Donia12215 ,

With line you do not have option to use secondary axis, when you use legend. So I doubt that

[Donia12215]

Thank you for your answer. Do you happen to know different way I could use to show variances for programs and all organisation? Maybe something from "get more visuals"?