Measure or calculated column?

[Anonymous]

Hello guys,

I have the following data source (it will eventually be a SharePoint list).

I need to add the following calculations (in red) and preferably end up with a nice matrix tile but i have just started with PowerBI and I am struggling to come up with the right steps. I have watched quite a few tutorials, so I should be able to progress with some help.

Thanks a lot for your guidance!

Object Type     Object Name                   Skill A                                     Skill B                                                 Skill C     

Employee	Employee 1	5	1	3
Employee	Employee 2	0	3	4
Employee	Employee 3	4	5	3
Employee	Employee n	2	5	0
Requirement	Requirement for task	1	1	5
Requirement	Requirement for cover	2	1	2
	Available skills	Counts all values>2 in Column Skill A where Object  = "Employee"	Counts all values in Skill B Column >2 where Object  = "Employee	Counts all values in Skill C Column >2 where Object  = "Employee"
	Single Point of Failure	Counts all values in Skill A Column =3 or 4 where Object = "Employee"	Counts all values in Skill B Column =3 or 4 where Object  = "Employee	Counts all values in Skill C Column =3 or 4 where Object  = "Employee"

Kind regards,

Zara

[parry2k]

@Anonymous you should unpivot your table and then you just need two measures to make it work.

Available Skills Measure = 
CALCULATE ( COUNTROWS ( Table ), Table[Value] > 2, Table[Object] = "Employee" )

Single Point of Failure  Measure = 
CALCULATE ( COUNTROWS ( Table ), Table[Value] >= 3, Table[Object] = "Employee" )

And you can visualize the data with these measure. Hope this helps. 

[parry2k · Accepted solution]

@Anonymous solution attached, you can tweak it as per your need.

Would appreciate Kudos 🙂 if my solution helped.