Forum Discussion
Advocate IPresence/Absence Counts and Percentages in a single Matrix
I have a tough time getting my head around how to show counts and %, cumulative % using a simple matrix, as my users aren't familiar with PBI yet and like to look at static "slides".
A lot of my data is counts and % with some filters of absent/present of each attribute, like this one:
I have measures to count the number of items for each attribute and separate measures to calculate their % of total but can't get them into a single matrix based on present/absent values for each. I have the format tool selection "Show on rows" = ON.
e.g.:
Company Ct = Count (Insight_TestOutput[Company])
PostalCode Ct = COUNT (Insight_TestOutput[Postal Code])
PostalCode % = [PostalCode Ct]/[Company Ct]
"Company" is my base value. It is always 100% as it is a required input. So I use a Company Ct measure as my denominator. I need to complete the chart past the Present-Count column.
Also, any websites with beginner/intermediate matrix lessons are much appreciated!
| Attribute | Present Count | Present % | Absent Count | Absent % |
| Company | 100 | 100% | 0 | 0 |
| Address | 90 | 90% | 10 | 10% |
| City | 25 | 25% | 75 | 75% |
| State | 55 | 55% | 45 | 45% |
| Postal | 15 | 15% | 85 | 85% |
| Country | 98 | 98% | 2 | 2% |
| Telephone | 25 | 25% | 75 | 75% |
9 Replies
v-jiascu-msftMicrosoft Employee
Hi sotoc,
Can you share your file? A dummy is enough. We can put them in a Matrix. Did you get any error messages? Please also refer to power-bi/desktop-matrix-visual.
Best Regards,
Dale
- sotoc
Hi Dale, thank you for the assistance. I am not getting errors but want to find out the most efficient way to create this matrix.
Much appreciated!
Carly
- sotoc
Hi Dale v-jiascu-msft, will you please give me an idea of turnaround on this? I've never submitted a request from the help team so don't have a reference point of timing. Thank you!
Carly- v-jiascu-msft
Hi Carly,
Sorry, I can't access the link. Seems I don't have permission.
Best Regards,
Dale
