Forum Discussion
Multiple Category Matrix without Drilldown
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!
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
3 Replies
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
