Total Summary of matrix table

[jwhralnareez]

My problem is how to show the total of columns value x total of row value .
My work sheet is 3 different training titles a,b and c.
staff name
Attending each training will give value 1 .
Let suppose that I have 3 employees
Emp 1 attend training a and b
Emp 2 attend training b and c
Empl 3 attend a , b and c
My need is to show who complete 3 training regardless the title and who did finish 2 of them and also only 1 title as total like in our example will be
1 title 0
2 titles 2
3 titles 1

 

[mart37]

Add a calculated column
Total:=
VAR empl=Table1[employee]
RETURN CALCULATE(SUM(Table1[training a])+SUM(Table1[training b])+SUM(Table1[training c]),FILTER(Table1,Table1[employee]=empl))

Add 3 measures like:
count 1:=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Total]=1))

 

[jwhralnareez]

Kindly see the attached photo