Forum Discussion

athren's avatar
athren
Frequent Visitor
5 years ago
Solved

Pass Fail Inspection Score Average?

I am new to PowerBi, I work in a Hospital within the Housekeeping department. In essence we are trying to calculate inspection scores for our visual room inspections. In the past I created an Excel s...
Need Help
  • athren's avatar
    athren
    5 years ago

    When all else fails and I ask for help, I ended up figuring it out the very next day. However if other people find themselves in the same situation this is what I did....



athren's avatar
athren
Frequent Visitor
5 years ago

When all else fails and I ask for help, I ended up figuring it out the very next day. However if other people find themselves in the same situation this is what I did....



  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi, athren 

    It's pleasant that you can share your sloution to us, people who meet a similar problem will be very happy with it.

    Please accept your reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

    Best Regards,
    Community Support Team _ Eason

  • sidoacm's avatar
    sidoacm
    Regular Visitor
    3 years ago

    Hi, I am trying to calculate the same formula for my data.  Did you write a measure for each column [Cabinets], [Ceilings], etc... and then plug that into the IF function? My version of your solution is not working.

     

    Thank you!