Forum Discussion
Create a virtual table using dax which only contain the selected multi select slicer values
I have a category table, and multi select filters contains category column, I am trying to create table using Dax which will only show the data of categories filtered by slicer. Can we do it in Power...
In that case you can use something like
CALCULATE(MIN(Table[Index]),ALLSELECTED(Table[Category Name]))
Yes, and even if we select more category, it should show the minimum.
lbendlin
Super User
Super UserIn that case you can use something like
CALCULATE(MIN(Table[Index]),ALLSELECTED(Table[Category Name]))
I had tried this and it is working. Thanks