Forum Discussion
Measure or calculated column?
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
Anonymous solution attached, you can tweak it as per your need.
Would appreciate Kudos 🙂 if my solution helped.
2 Replies
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.
Anonymous solution attached, you can tweak it as per your need.
Would appreciate Kudos 🙂 if my solution helped.