Forum Discussion

fereshtehaghaei's avatar
fereshtehaghaei
Helper II
2 years ago

Satisfaction Rate Calculation In Power BI (Likert Scale)

I am fairly new BI users. I am working on students evaluation survay. 

I have all this built in Tableau and now need to re-built my dashboards in Power BI. Is this even doable in power BI or are there different or less steps to take to get this result:

 

My Tableau Calcualted Field Steps in order to get me the Satisfaction Rate:

  1.  Combined ResponseID Question ID =    [Response Unique ID]+"-"+str([Question ID])
  2.  Promoter =  IF  [Response] = "Strongly Agree"  OR  [Response] = "Somewhat Agree" 

                        THEN  [Combined Response Question ID]

                        ELSEIF [Response] ='Not Applicable' THEN [Combined Response Question ID]

                        END

  3. Numerator=   COUNTD ( IF  [Category]="CA" THEN [Satisfaction Numerator (Promoter )] END)

  4. Denominator= COUNTD([Combined ResponseID Question ID])

  5. Satisfaction Rate % = Numerator / Denominator

How Would I acheive this in Power BI, I have followed and tried multiple ways and calculations but nothing gives me the desired results. I have a sample of my Power BI file attached so if anyone want to look into this, you can see all my Power BI (DAX) calculations. I even re-did my table connections but nothings seems to give me the result I am looking for.

I really would appreciate it if anyone want to tackle this and help me out please.

 

https://drive.google.com/file/d/18udf1Ygl-PDC9Jba5-f8ymvzFcdW-w5S/view?usp=drive_link

 

 

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    First thing you'll want to do is fix your data model

     

     

    And then you would want to describe your business goal in natural language (not Tableau formulas)  so you can implement it in Power BI.

  • fereshtehaghaei's avatar
    fereshtehaghaei
    Helper II
    2 years ago

    Thanks lbendlin I did fix my Model thank you for your guidance; I had to choose Both as a cross filter for two of the table connections since I am using filters. I need to calculate Overall Satifaciton Rate then break it down (by filtering) to Hosptial Level and then to Unit leve.  My satisfaction measure are Strongly Agree and Somewhat Agree, I need to get the count of these response choices and treat it as a numerator and then divide that by the # of respondents. I want to see How satisfied each student was in an Agency (overall satisfaction) as well as their satifaction in that Unit. Does this descirbes it any better in natural language? Thank you for looking into this!

     

    This is what the results shoud look like (my tablea screenshots, since I dont' have this any other way)

    Agency Overall Satisfaction 

     

     Then I click on an Agency to see the its Unit's satisfaction:

    This is what I have in Power BI (even before the model change I made) 

    This is what I have in Power BI (even after the model change I made)