Forum Discussion
kangkopi15
Helper I
Helper ICount 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
Hi kangkopi15
Average = calculate(average(utilisation), AND((activityfullname <> "partime off"),(activityfullname <> "Unassigned"))I hope I answered your question!
Uzi2019
Community Champion
Community ChampionHi kangkopi15
Average = calculate(average(utilisation), AND((activityfullname <> "partime off"),(activityfullname <> "Unassigned"))
I hope I answered your question!
kangkopi15Helper I
Helper Iits working, thank you