Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
  • lbendlin's avatar
    lbendlin
    2 years ago

    In that case you can use something like 

     

    CALCULATE(MIN(Table[Index]),ALLSELECTED(Table[Category Name]))

Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 

Here you are creating table using dax. Table doesn't work dynamically based on slicers. 

The table to be created inside a measure and then the required comparison to be done there itself.

Please share some sample data and your desired out put. Will try to solve