Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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. 🙂
Solved! Go to 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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
50 | |
24 | |
19 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
22 |