Line Graph Sum Value

[jamescosten]

I have a line graph which is showing lines as Open & Closed totals. What i need is a third line that shows the difference between the two values. Open =10, closed =1 then the new line should show a value of 9 and is shown on the graph. Is this possible?

[Satya_Bhamidipa]

Create new calculated column

Use 3 columns

Check result

Please let me know if you need more inputs 

[James-Harpin]

@jamescosten the table name that the closed and open columns are in, if these are measures you do not need the table name just the measure names

[jamescosten]

Getting the above error. The table is Non Conformance Database, but the column is status and the options are Open & Complete which is a choice field.

[James-Harpin]

@jamescosten Would you be able to send an example of your table structure

[jamescosten]

[James-Harpin]

@jamescosten what are you using for the axis/values in your line chart?

[jamescosten]

[James-Harpin · Accepted solution]

@jamescosten 

I would create 3 measures:

Then put into a line chart:

[James-Harpin]

Hello @jamescosten 

Try creating a calculated column with the following DAX formula:

Difference =

('Table (2)'[Open]) - ('Table (2)'[Closed])

[jamescosten]

So i have the new column, i have the above expression but whta is table meant to represent? 

[Satya_Bhamidipa]

Create new calculated column

Use 3 columns

Check result

Pls check above option and let me know if you need more inputs 

[jamescosten]

The table does not have a column with open or closed, it is one column with choices. The formula doesnt work.