Use slicer value/s as a filter in a measure

[devGV_88]

Hi folks,

I looking for a way to capture the values selected in a slicer.

I tried with VALUE, VALUES and SELECTED VALUES, but did not work...

This is my calculated table, where I want to sum the total by date/hour... And the dinamic filter should be the City.

Using {"USA"} works, and more than one city. But I need replace it withthe value from the slicer selection (1 or more than 1 city...)

[Pravin_]

Are you storing this calculated table in the model as a physical table?

In this case I don't think it will be interactive with slicers on the report page

[Greg_Deckler]

@devGV_88  In your FILTER use [City] IN DISTINCT('SlicerTable'[Value])

[devGV_88]

Hi @Greg_Deckler 

I tried it, but I got this error: A table of multiple values was supplied where a single value was expected.

[Greg_Deckler]

@devGV_88 Can you post sample data?

[devGV_88]

Let me know if works...

ExampleFile 

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[devGV_88]

@Greg_Deckler
How can I attach the pbix?