topic Re: Create a virtual table using dax which only contain the selected multi select slicer values in DAX Commands and Tips

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

Anonymous — Fri, 30 Aug 2024 11:34:36 GMT

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

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

lbendlin — Fri, 30 Aug 2024 13:02:04 GMT

use VALUES or FILTERS

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

Anonymous — Fri, 30 Aug 2024 14:45:06 GMT

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.

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

Rupak_bi — Fri, 30 Aug 2024 21:35:27 GMT

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

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

Anonymous — Sat, 31 Aug 2024 11:25:56 GMT

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.

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

lbendlin — Sat, 31 Aug 2024 14:31:06 GMT

Are you expecting to show a 2 for C ?

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

Anonymous — Sun, 01 Sep 2024 04:04:36 GMT

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

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

lbendlin — Mon, 02 Sep 2024 00:36:23 GMT

In that case you can use something like

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

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

Anonymous — Mon, 02 Sep 2024 09:39:14 GMT

I had tried this and it is working. Thanks