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)....
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")))
amitchandak
Super User
Super UserRafapolanco , 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")))