Count average with except state column power BI

[kangkopi15]

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

[Gabry]

What's you issue?

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

[kangkopi15]

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 · Accepted solution]

Hi @kangkopi15 

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

I hope I answered your question!

[kangkopi15]

its working, thank you