Keep results from a matrix visual when using slicers and a measure with ALLSELECTED

[Anonymous]

Hi,

I have this visual matrix where I show some results from a measure:

The measure used is:

Measure = SUM('Table1'[Results]) / CALCULATE(  SUM('Table1'[Results]) , ALLSELECTED('Table1'), VALUES('Table1'[Date]))

What I need is, when I use a slicer for the column "Shipper" and select a value, I need to keep the results of the previous image, (is the scenario where I don't select any slicer value):

When I select a value from the slicer, the matrix will return this:
The Table1 is something like this (the 'results' are just examples):

Shipper	Date	Results
SHIPPER 1---	jul/22---	102
SHIPPER 2---	jul/22---	408
SHIPPER 3---	jul/22---	502
SHIPPER 4---	jul/22---	42
SHIPPER 5---	jul/22---	4
SHIPPER 6---	jul/22---	21
SHIPPER 7---	jul/22---	525
SHIPPER 1---	ago/22---	78
SHIPPER 2---	ago/22---	213
SHIPPER 3---	ago/22---	210
SHIPPER 4---	ago/22---	802
SHIPPER 5---	ago/22---	20
SHIPPER 6---	ago/22---	17
SHIPPER 7---	ago/22---	43
etc...---	etc...---	etc...

Thank you for your help, community, 

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

You can change ALLSELECT() to ALL()

Measure2 =
SUM('Table1'[Results]) / CALCULATE(  SUM('Table1'[Results]) , ALL('Table1'), VALUES('Table1'[Date]))

The ALLSELECT() function preserves the context beyond the explicit filters and the row and column filters, and the values change as the data is filtered.

ALLSELECTED function (DAX) - DAX | Microsoft Learn

The ALL() function returns all values in all rows or columns of a table, ignoring any filters that may have been applied.

ALL function (DAX) - DAX | Microsoft Learn

Best Regards,

Liu Yang

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