Using a table visual, splitting one column (enrolled and not yet enrolled) into 2 columns

[Anndre]

Hello,

This is my table column. I want to display the COUNT of enrolled and not yet enrolled in every route. 

Here's my table visual (left) in power bi. I can only display count of enrolled or not enrolled or both. I want to display the count of both enrolled and not enrolled in two separate columns in one table.

And in another column I need it to display a percent of the enrolled column. Let's say I have 100 enrolled accounts in route 1, I want to display a target of 90%. So the column will display 90.

Thank you!

[Anndre]

Thanks for answering! It's my first time using power bi. So I am not so sure about the formula or expression to use.

Please help.

[Idrissshatila]

Hello @Anndre ,

so you prepare 3 seperate measure that would display the count of enrolled, count of not enrolled, and the percentage and add three of them to the values of the table and they will display beside each others.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Anndre]

Thanks for answering! It's my first time using power bi. So I am not so sure about the formula or expression to use.

Please help.