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 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
In that case you can use something like
CALCULATE(MIN(Table[Index]),ALLSELECTED(Table[Category Name]))
8 Replies
- lbendlin
Super User
use VALUES or FILTERS
- Rupak_bi
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
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 ?
