Forum Discussion
undefined
Hi timthy ,
Could you provide more details, such as screenshots, dax and sample data? This will help us better understand your question.
Have you tried creating two measures to calculate the average filtering by team name and date respectively?
_name = CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[TeamName]))_date = CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[Date]))
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.
Best regards,
Mengmeng Li
I was working on a table visual to show Task Type, Individual Avg, Team Avg, and the Difference, with Name and Date as slicers. I created two measures—one for Individual Avg and one for Team Avg using the ALL function. The issue was that when filtering by both Name and Date, the Team Avg wasn’t calculating correctly (since ALL was only removing the Name filter).
To fix it, I duplicated the table and created the Team Avg measure in that new table. Then, I made a separate Date table and connected it to both tables. Now, the Team Avg stays correct even when filtering by both Name and Date!