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!

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!

kangkopi15's avatar
kangkopi15
Helper I
2 years ago

its working, thank you