How to calculate based on 2 filtered data

[Rafapolanco]

Hello Community!

I want to get a new variable or measure for represent in a line the ratio between the sum of a variable (filtered by Won) and the sum of the same variable (but filtered by Lost). Here a representation:

I would like to calculate for each person, the ratio Won/lost. How could I do it?

[amitchandak · Accepted solution]

@Rafapolanco , Create new measure like

Divide(calculate([number of deals], filter(Table, Table[deal status] ="Won")), calculate([number of deals], filter(Table, Table[deal status] ="Lost")))