topic Re: How to count the occurrences of the a specific value in a column in DAX Commands and Tips

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

jllprz — Tue, 16 Apr 2024 02:36:14 GMT

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. 🙂

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

Jihwan_Kim — Tue, 16 Apr 2024 03:07:31 GMT

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.

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

jllprz — Tue, 16 Apr 2024 03:13:03 GMT

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.

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

Jihwan_Kim — Tue, 16 Apr 2024 16:08:46 GMT

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.