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
I create a sample file,but didn't find anything wrong.
I guess that you may missing some filter conditions in measure Average Job Type Cost . If possible , can you share your sample data/pbix file for testing?
How will the table visual display if you only apply the field "Job type" and "Average Job Type Cost " to the table "Values" ?
Best Regards,
Community Support Team _ Eason