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
I cannot get this to fail.
Total Average = CALCULATE(AVERAGE(Table1[Amount]),ALL(Table1))
That always shows the average for everything in the table for me, regardless of a date filter/slicer.
Reg Average = AVERAGE(Table1[Amount])
This changes with the slicer, as it should.
Can you post your PBIX so we can see if there is anything else going on in there? Though I cannot imagine what. You are removing the filters from the entire table, not just a column. I know if you are sorting [Score] by another column you have to remove the filter from both [Score] and the sorting field, but that shouldn't be relevant since you are using ALL(TableName) with no columns specified.