Create a virtual table using dax which only contain the selected multi select slicer values

[AkankshaRai_123]

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 PowerBI Ultimate Problem Statement: - If I have 3 categories A, B and C with respective Index column. If my slicer selects A & C, then my virtual Table shows only A and C Category data, by which I will create a measure for Min (Index), for Comparison of Category C vs Category A data. @Microsoft

[AkankshaRai_123]

@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.

[lbendlin]

Are you expecting to show a 2 for C ?

[AkankshaRai_123]

Yes, and even if we select more category, it should show the minimum.

[lbendlin · Accepted solution]

In that case you can use something like 

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

[AkankshaRai_123]

I had tried this and it is working. Thanks

[Rupak_bi]

Hi @AkankshaRai_123 

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

[lbendlin]

use VALUES or FILTERS

[AkankshaRai_123]

In the below snapshot, I have created dax based Table 2 which need to give only filtered values from Table.

However, that isn't the case.