I have a dataset with all requests in a buisness.
There can be 1 or more [Order] within a [Request]. And 1 or more [Appointment] within an [Order]. After each Appointment is completed a [Score] of 0-5 is provided by the customer. Not every customer will provide a score, hence some of the nulls.
Example dataset provided below:
| Request | Order | Appointment | Score |
| 1234 | 1001 | App - 1 | 4 |
| 4567 | 1002 | App - 2 | 5 |
| 4567 | 1003 | App - 3 | 5 |
| 6789 | 1004 | App - 4 | 1 |
| 4321 | 1005 | App - 5 | 4 |
| 6543 | 1006 | App - 6 | 3 |
| 6543 | 1007 | App - 7 | 5 |
| 6543 | 1008 | App - 8 | 5 |
| 9123 | 1009 | App - 9 | |
On the [Request] level, I am looking to calculated the count of [Request], where [Score] = 4 or 5. Below is the calcualation for Tableau, how would I convert this to PowerBI?
{ FIXED [Request]: max(IF [Score] = 5 then 1
ELSEIF [Score]= 4 then 1
else 0
END)}
