Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Phil22
New Member

Adding a measure to a matrix that is counting values

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.

 

Phil22_0-1622052711904.png

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

3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

Hi, @Phil22 

 

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

 

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
Super User
Super User

@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 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.