Forum Discussion
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
Hi kangkopi15
Average = calculate(average(utilisation), AND((activityfullname <> "partime off"),(activityfullname <> "Unassigned"))I hope I answered your question!
What's you issue?
Average = calculate(average(utilisation), activityfullname <> "partime off")
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
Hi kangkopi15
Average = calculate(average(utilisation), AND((activityfullname <> "partime off"),(activityfullname <> "Unassigned"))I hope I answered your question!
its working, thank you