Forum Discussion
Solved
ALL() function not working as expected
Hi, I've perused the similar forum posts but I still can't get ALL() to work as I believe it should. I'm trying to create a measure that calculates an overall average of a column -- that is, an ...
So you said it changes when you apply your date slices, is the date field in your slicer from your main table or from a separate calendar/date table. If it's from a separate table try putting the all statement around that field/table instead
So you said it changes when you apply your date slices, is the date field in your slicer from your main table or from a separate calendar/date table. If it's from a separate table try putting the all statement around that field/table instead
Thanks all for the assistance! Anonymous was on the right track and prompted me to try adding ALL() filters to the CALCULATE() function for each dimension table in my data model (including my Calendar table), like this:
Overall Score Average = CALCULATE(AVERAGE(Job_info[Score]), ALL(Job_info), ALL('Calendar'), ALL(dim_1), ALL(dim_2), ALL(dim_3), ALL(dim_4), ALL(dim_5), ALL(dim_6), ALL(dim_7), ALL(dim_8), ALL(dim_9))Now my "Overall Score Average" doesn't change when I make slicer selections in slicers using those dimension tables.