Total number of rows in a Matrix based on column 1

[shanco]

I am trying to build a report which we use to show one of government agencies how many employees were trained by a specific trainer. I have built the report using the Matrix vizualization, but I just need a count of the number of employees they trained in the far right column. I would solve this in Excel with a sumif calculation. The Matrix is setup with the Trainer and the Employee in the Rows section and the Skills are under the Values section. Here is what I need to build:

Additionally, is there a way to do it this way?

[AllisonKennedy]

@shanco

How far have you gotten with this?
You should be able to add Employee into the Values as well as Skills Tested and that should give you the count, and the subtotals will give you the 3, 2 values you want.

Otherwise you can make an explicit measure:

Count Employees = Count(table[employees])

The sumif will be done automatically by the matrix visual.

You can play with the formatting of the matrix, such as adjusting the stepped layout or turning it off to get the last image you want:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#stepped-layout-with-matrix-v...

[shanco]

Thank you @AllisonKennedy 

When I move Employee down to value, I only get these options - First, Last, Count, Count (Distinct). How do I get it to show all of the employees?

[AllisonKennedy · Accepted solution]

@shanco

Keep employee in Rows, but also add to Values (you can drag it from the fields pane directly).

Otherwise try the measure I suggested.

You will want to choose 'count' as the option.

[shanco]

Thanks @AllisonKennedy 

This did the trick. I am getting much closer.

I now get this:

If I add subtotal I get this:

Is there a way to remove the attempt to total the Skills Tested column? I just want the count column to be totaled.

[AllisonKennedy]

You can either create a custom measure for Skills tested so that it doesn't try to total when more than one employee is selected (search measure totals problem by @Greg_Deckler) or move Skills Tested to Rows.

[shanco]

I solved the last part of hiding the totals for the text columns by using the Field formatting option as described at: https://radacad.com/removing-the-total-value-for-a-column-in-the-table-visual-of-power-bi-using-isfi...