How to add total line in garaph

[Amjad1002]

Hi everyone.

I have three categories in one column and I am making line graph but I want to add 4th line which can show me total on top line.

These three contegries in one column.

Thanks

[Amjad1002 · Accepted solution]

No worries, I found the solution myself by making three conditional column and add them up will solve this issue.

[Anonymous]

Hi @Amjad1002 ,

Congratulations on solving this issue and thanks for sharing your solution.

Please remember to accept your solution as answer.

It will do great help to those who meet the similar question in this forum.

Thanks again for your contribution.

[moncx]

How do you calculate lines? Are there 3 separate measures or is there 1 measure but you add some column to legend part?

Because if there is 3 separate measures then just create additional one which sums up previous three ones.
Measure all = [Measure 1] + [Measure 2] + [Measure 3] 

If you have one measure or calculation based on column and then separate it in graph, then you need to create separate measure for all 3 ACTIONWORKDONE and the one for total.

Measure 1 = CALCULATE(COUNT(Table[column]), Sheet2[ACTIONWORKDONE]="CV")

Measure 2 = CALCULATE(COUNT(Table[column]), Sheet2[ACTIONWORKDONE]="CV&OPS")
Measure 3 = CALCULATE(COUNT(Table[column]), Sheet2[ACTIONWORKDONE]="OPS")
Measre total = [Measure 1] + [Measure 2] + [Measure 3]

Then you will get view like this:

[Amjad1002]

Hi,

it is only one measure and its contents not number. such as CV, CV&OP and OPS.