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 h...
Anonymous solution attached, you can tweak it as per your need.
Would appreciate Kudos 🙂 if my solution helped.
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.