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]))
Rupak_bi
In the below screenshot, min selected index should show only minimum Index number out of all selected category's Index.
Not sure how can I share the file however, below is the sample data snapshot.
P.S. A measure is required which will show the Minimum index value from selected values of Multi Select slicer list. We can do this in Card visual easily, but I need a measure for Matrix visual.
