Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)}
@dogt1225 , refer my video on that, you can directly jump on the power bi part
LOD- FIXED (Level of Details) - Revisited: https://youtu.be/hU-cVOwDCvY
Check
Tableau Vs Power BI: https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |