- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Presence/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% |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Carly,
Sorry, I can't access the link. Seems I don't have permission.
Best Regards,
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi there Dale, were you able to open the second file? Thanks so much,
Carly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for this demo @v-jiascu-msft!
I can't figure out what I am missing here, but when I reproduced your unpivot and created your measures, my Absent counts/% are good. But I get the file's total row count for each of the attributes. My source .csv file is clean without spaces in the cells.
If I enter a new measure "Count Diff" as the difference between the Present Count (showing 49 for each attribute), my result will be the true "Present" values you show.
Count Diff = CALCULATE(COUNT(CustomerInput[Value]) - ([Absent]))
Attribute | Count of Value | Present | Present % | Absent | Absent % | Count Diff |
Account | 49 | 49 | 100% | 0 | 0 | 49 |
Address | 49 | 49 | 100% | 7 | 14% | 42 |
City | 49 | 49 | 100% | 7 | 14% | 42 |
Country | 49 | 49 | 100% | 2 | 4% | 47 |
Postal | 49 | 49 | 100% | 6 | 12% | 43 |
State | 49 | 49 | 100% | 7 | 14% | 42 |
Total | 294 | 294 | 100% | 49 | 100% | 265 |
Thanks again for any additional guidance on producing the correct Present results.
Carly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Carly,
Can you send me the file? It would be easy to troubleshoot with file.
Best Regards,
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-30-2024 01:07 PM | |||
07-05-2024 11:01 AM | |||
02-13-2025 11:03 AM | |||
Anonymous
| 07-20-2018 04:45 AM | ||
02-01-2023 02:35 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |