Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table of the format
Date Result
4/11 F
4/11 F
4/12 P
4/12 F
4/12 P
I need to get the average of pass and fail records per date to plot a chart as below
Date PassAvg FailAvg
4/11 0 100%(i.e,2*100/2)
4/12 66.6% 33.3%
How can I achieve this?
Solved! Go to Solution.
There's 2 ways to do this. I'll give you both because inevitably someone will read this and try to give you the easy way...
First (not the way I would do it - but its faster)
You need to write only 1 Measure - and create a Matrix - place fields as in the picture!
Second you have to write 5 simple Measures but it gives you more flexibilty later on... for other visualiazations including charts
I may post a chart later which you can't do with the first method
Hope this helps!
There's 2 ways to do this. I'll give you both because inevitably someone will read this and try to give you the easy way...
First (not the way I would do it - but its faster)
You need to write only 1 Measure - and create a Matrix - place fields as in the picture!
Second you have to write 5 simple Measures but it gives you more flexibilty later on... for other visualiazations including charts
I may post a chart later which you can't do with the first method
Hope this helps!
Hi,
But what about the dates grouping, in this case by day?
Fernando
The secod solution works perfectly. I had one question though, how did you add the percentage sign for Avg measures?
Modeling Tab => Format: => select Percentage
Thank you so much. Sorry for my ignorance,I am new to excel and power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |