Forum Discussion
Average with ALL/ALLEXCEPT returning wrong value
Hello all, I'm trying to calculate an average value with some ALL and ALLEXCEPT filters but the value being returned is incorrect and I don't know why. I have data with suppliers and job type...
Hi SamFletch
Do one thing use this Dax to calculate the average = averagex(allselected(supplier),total cost). This will give you the result.
Kindly mark this solution as accepted.