How to create a line chart, from value in one column

[Anonymous]

Hi everyone. 

May I know how can I filter value from one column to become 2 and to put in line chart/

For example, based on the picture below. Amount that have contract (100 + 100 + 100) , should put inside "values" in the line chart. and Amount that is non-contract have to put inside 'Secondary value" in the line chart. 
May I know how can i do that ?

Thank you so much 

[amitchandak · Accepted solution]

@Anonymous , You have to create two measures, if you need two axes. For the same axis, you can use legend (contract/non contract)

M1 = calculate(sum(Table[Amount]), filter(Table, Table[contract/non contract] = "Contract" ))

M1 = calculate(sum(Table[Amount]), filter(Table, Table[contract/non contract] = "Non Contract" ))

[Anonymous]

Hi, Thank you so much !! it works !!