Forum Discussion
Solved
How to calculate based on 2 filtered data
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?
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")))
1 Reply
- amitchandak
Super User
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")))