Please forgive my slow thinking, but I have no idea what is do mean by grouping, please provide a visual like so
And also provide input what approach of the suggestions you are using
I just wanted to show Pass/Fail in Pie Chart rather than column chart.
maybe this would be a solution, I'm counting the caseid (distinct count) to get the numbers in this table
I did not use a measure I just changed the Aggregate function in the visuals pane and renamed the column in the visual
Maybe now I'm getting closer
Thank you so much,
I took the hint from smoupre solution and create a measure like:
FAIL= CALCULATE(DISTINCTCOUNT(testcasetbl[TCtitle]),FILTER('SmokeCase',[Latest Status]="FAIL"))
But your solution is definitely much simpler. Thanks a alot.
Glad we were able to help once again.
Maybe you also consider to create another measure lilke this
No of Cases =
Personally I find such a measure really beneficial in combination with columns like "latest status"
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.