Presence/Absence Counts and Percentages in a single Matrix

[sotoc]

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%

[v-jiascu-msft]

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 @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

[sotoc]

Please try this one. Thank you!

 Sample Data - Absence/Presence

[sotoc]

Hi there Dale, were you able to open the second file? Thanks so much, 

Carly

[v-jiascu-msft]

Hi Carly,

I'm afraid we have to change the format of the original data table. Please refer to the demo in the attachment.

Best Regards,

Dale

[sotoc]

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

[v-jiascu-msft]

Hi Carly,

Can you send me the file? It would be easy to troubleshoot with file.

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.

Sample Data File - C. Soto

 Much appreciated!

Carly