Adding a measure to a matrix that is counting values

[Phil22]

I've made a matrix as pictured below.  The LastResultOutcome column has the values "None", "Paused", "Failed", or "Passed".  The matrix below is simply counting each of those values as they are grouped into the interface rows.

What I would like to do is add two additional columns.  One would be called "Tests Run" which would be (Failed + Passed) / Total.  And the other column would be "Tests Passed" which would be Passed / (Passed + Failed).  Both are a percentage.

I've found plenty of tutorials on measures and calculated columns, but they all seem to apply to the number values in the dataset, not a count of text fields based on groupings in a matrix.

How could I add those columns?

Thank you

[v-janeyg-msft]

Hi, @Phil22 

What do you mean by ‘count text value’? If you can show the results you want, it may be easier to understand.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Phil22 
 There no straightforward way of doing it, but you can almost get the desired results: 
Check out this video: https://www.youtube.com/watch?v=gieoBW7fTUI 

[Phil22]

I watched that one already 🙂

It didn't seem to work for me as I need it to add up the count of a column based on it's value.  That video uses measures that are number values, not a count of text values.