Forum Discussion
undefined
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
The ALL function removes all filters on the specified table or column(s). That means other filters may still be active.
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
