Forum Discussion

vlassauw's avatar
vlassauw
Frequent Visitor
8 years ago
Solved

Average Issue

The Power BI Query In my Power BI query I have a Department and an Employee level I have a measure called HoursWork and measure called HoursSick I need percentage hours sick on hours worked In th...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    That 25.71% looks to be an average of the individual percentages - it's nothing to do with taking into account (or otherwise) the rows where nobody's sick. The original measure posted in reply should work absolutely fine, and I'm thinking it's something to do with how the visual is interpreting the totals row

     

    edit - just put in the data you listed and the measure listed and it works correctly out of the box:

     

vlassauw's avatar
vlassauw
Frequent Visitor
8 years ago

Thank you for responding but it doesn't work, as in Power BI the measure needs to be aggregated,

If you choose Average, it will still take the 0% rows into account. Other aggregation types, as far as I can see are pointless

If you choose Don't Summarize my report is ungrouped which is not an option.

jthomson's avatar
jthomson
Solution Sage
8 years ago

That 25.71% looks to be an average of the individual percentages - it's nothing to do with taking into account (or otherwise) the rows where nobody's sick. The original measure posted in reply should work absolutely fine, and I'm thinking it's something to do with how the visual is interpreting the totals row

 

edit - just put in the data you listed and the measure listed and it works correctly out of the box:

 

  • vlassauw's avatar
    vlassauw
    Frequent Visitor
    8 years ago

    Somehow it refreshed wrong when I tried your formula, so i tried again and it works, thank you!!!!

    • vlassauw's avatar
      vlassauw
      Frequent Visitor
      8 years ago

      The mistake I made was I applied the formula to a column in stead of a measure