Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dogt1225
Helper II
Helper II

Tableau Fixed LOD to PowerBI

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:

RequestOrderAppointmentScore
12341001App - 14
45671002App - 25
45671003App - 35
67891004App - 41
43211005App - 54
65431006App - 63
65431007App - 75
65431008App - 85
91231009App - 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)}

 

 

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.