Create measure from original source, regardless of slicer choices

[CloserMKD]

I have a source table that is filtered by a time slicer.

What I what to know is whether it's possible to create a measure that uses data from that source table, but not filtered by the slicer (i.e. to be like the original source). So, I need some of the measures to use the filtered source, and some of them not to depend on the slicer selection.

 Thanks in advance 🙂

[v-ljerr-msft · Accepted solution]

Hi @CloserMKD,

According to your description, you should be able to create the measure using ALL Function (DAX) which removes all filters from the specified table.

In effect, ALL(Table) returns all of the values in the table, removing any filters from the context that otherwise might have been applied. For more details about ALL function, please refer to this article.

Regards

[Anonymous]

Hi @CloserMKD

Please share some data and actual output expected.

Cheers

CheenuSing