Termination rate depending on dimension

[Anonymous]

Hello all,

I would like to display the terminations depending on the input channel in PowerBI. In a table I have:

Customer_ID	Channel	Termination
1	none	No
2	D2D	No
3	Online	Yes
4	Shop	Yes
5	Shop	No

I would now like to display the terminationrate in a scaled bar chart.
I can manage the number of terminations per channel. To do this, I simply place the channels on the axis and the number of terminations as values.
But how can I calculate the terminationrate depending on the channel?

Thank you in advance for any tips.

[amitchandak · Accepted solution]

@Anonymous , Try one of the three measures

Divide(calculate(count(Table[Customer ID]), filter(Table, Table[Termination] = "YES")), calculate(count(Table[Customer ID])))

Divide(calculate(count(Table[Customer ID]), filter(Table, Table[Termination] = "YES")), calculate(count(Table[Customer ID]), allselected()))

Divide(calculate(count(Table[Customer ID]), filter(Table, Table[Termination] = "YES")), calculate(count(Table[Customer ID]), allexcept(Table, Table[Channel])))