How to count the occurrences of the a specific value in a column

[jllprz]

So, I am working on a project and it has 300,000 rows (which are consumers). Then I have a column named, Target. That target is to know if that consumer defaulted his or her account. So the column has 2 values (1 or 0), 1: Account default and 0: Did not default. I want to know how many values of 1 and how many values of 0 are there in the Target column. I also want to see in a pie chart, the percentage of people that defaulted their accounts and those who did not.

Thank you. 🙂

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

[jllprz]

Thank you so much! This is exactly what I needed! I appreciate it! Would you be able to type down the formula? I'm sorry, I'm currently on my phone right now and would love to see the formula. Thank you so much again.

[Jihwan_Kim]

Hi, I did not write any measure but just drag and drop to the visualization.

If you have your sample pbix file, but if it does not work, please share your sample pbix file's link and then I can try to look into it.

Thanks.