Forum Discussion

kangkopi15's avatar
kangkopi15
Helper I
2 years ago
Solved

Count average with except state column power BI

Guys, it's me again, I am struggling with getting the utilization average without the Part-Time (off), the expected value should be 100

 

Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi kangkopi15 

    Average = calculate(average(utilisation), AND((activityfullname <> "partime off"),(activityfullname <> "Unassigned"))

     

    I hope I answered your question!

4 Replies

  • Gabry's avatar
    Gabry
    Super User
    2 years ago

    What's you issue?


    Average = calculate(average(utilisation), activityfullname <> "partime off")

    • kangkopi15's avatar
      kangkopi15
      Helper I
      2 years ago

      Hi Gabry Apology, here is the complete table, I need to get the average utilization per Assignment, without Activity - Part Time and Unassigned in the calculation.
      so the expected utilization is Abel = 100 and Achimin 100

       

      • Uzi2019's avatar
        Uzi2019
        Community Champion
        2 years ago

        Hi kangkopi15 

        Average = calculate(average(utilisation), AND((activityfullname <> "partime off"),(activityfullname <> "Unassigned"))

         

        I hope I answered your question!