Power BI- All Function with Date Slicer

Hi ssarin ,

What parameter in the ALL function do you use, a table or a column? If it's a column, replace it with the whole table.

I create a sample to clerify:

And two measures:

Measure1 =
CALCULATE ( SUM ( 'Table'[Sales] ), ALL ( 'Table'[Category] ) )

Measure2 =
CALCULATE ( SUM ( 'Table'[Sales] ), ALL ( 'Table' ) )

Now can see, Measure1 which using a column in the ALL function changed with the slicer, but Measure2 which using a table in the ALL function didn't change with the slicer.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi ssarin ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj