Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am a beginner pbix user and cannot figure this one out. I cannot drilldown as it is being exported to PowerPoint as a static slide.
I have a table showing scores A, B and C that I need to count for each Score Type, e.g., how many customers have name_score A, how many Customers have name_score B, and so on.
Customer | name_score | brand_score | SIC_score | location_score | CEO_score | phone_score | domain_score | person_name_score |
1013338 | A | B | B | A | C | C | C | A |
1013536 | A | B | B | A | C | C | C | A |
1013627 | A | B | B | A | C | C | C | A |
1034425 | A | A | C | A | C | C | C | A |
1035398 | A | A | A | A | C | C | C | A |
1040497 | A | B | A | A | C | C | C | A |
1045116 | A | B | B | A | C | C | C | A |
1045509 | A | B | A | B | C | C | C | A |
Using a matrix I ultimately want it to look like the following table (% of row total) but in the spirit of learning I want to see how to do both the simple count and the percentages:
Score Type | A | B | C |
name_score | 73% | 25% | 2% |
brand_score | 12% | 50% | 38% |
SIC_score | 41% | 19% | 40% |
location_score | 86% | 13% | 0% |
CEO_score | 8% | 0% | 92% |
phone_score | 5% | 0% | 95% |
domain_score | 1% | 0% | 99% |
person_name_score | 90% | 9% | 1% |
address_score | 5% | 0% | 95% |
Thank you in advance!
Solved! Go to Solution.
Hi, you can in Edit Query Select Customer and Column And Unpivot Other Columns. Rename the columns like you desire. Close & Apply
After that in the matrix put in Rows the ScoreType in Columns the Score and in values Count of Customers.
If you want to see in % of Total Rows, Click on CountCustomer in Format Panel and select Show Value As --Percent of Row Total
Let me know if need more help
Regards
Victor
Lima - Peru
Hi, you can in Edit Query Select Customer and Column And Unpivot Other Columns. Rename the columns like you desire. Close & Apply
After that in the matrix put in Rows the ScoreType in Columns the Score and in values Count of Customers.
If you want to see in % of Total Rows, Click on CountCustomer in Format Panel and select Show Value As --Percent of Row Total
Let me know if need more help
Regards
Victor
Lima - Peru
here is the solution for you as suggested by @Vvelarde
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Wonderful, thank you Victor and Parry!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |