undefined

[timthy]

Hi I am facing an issue where the ALL function is not working. I am using a table to compare individual stats (avg items per hour) with overall team (avg items per hour) but for some reason the whne I use the slicer it's not working properly. If I just use the Name slicer it's working okay but when I bring the Date slicer (even when all the date range is selected)the team avg is changing when I try to filter by name. My goal is if the date range is selected it brings the overall avg for selected date range the I use the name slicer to select a name and then compare it side by side with the Overall tem avg for the selected date range (but the Overall avg value changes when it's being filetered) is there a solution or workaround (I've tried all other functions like removed filters to ALLEXCEPT, to ALLSelected nothing seems to work)

[Anonymous]

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

[timthy]

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!

[lbendlin]

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.

[timthy]

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