Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
@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
⭕ 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.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |