Display a filtered column based on slicer

[Anonymous]

Hi guys,

I would like to dynamically return a filtered column from a table and display on a table/matrix/card based on a slicer:

The following sample data illustrates my issue. I have a table that only contains all the strings for the slicer:

I have another table that contains IDs in one column and the same values from the slicer as they apply to the IDs.

No, I would like to display the IDs on a matrix (or table or card) filtered for the value that was selected by the slicer. For example, if I select "VW" in the slicer, I would like to display two rows containing 3 in the first and 31 in the second row.

All other visuals on the report only one value, therefore similar tasks were I was able to realize with a dynamic measure, as follows:

My Measure = 
SWITCH ( SELECTEDVALUE ( Table1[Column1] ),
 "Value1", SUM( Table2[Column1] ),
 "Value2", SUM( Table2[Column2] ),
 "Value3", SUM( Table2[Column3] )
)

Any suggestions? Thanks a bunch in advance!

Best,

Jonas

[MFelix · Accepted solution]

Hi @Anonymous ,

If your slicer and salestalk table are related you should use a measure similar to the one below:

Active Filter_ = 
Active Filter_ = 
 CALCULATE(
CONCATENATEX (
       DISTINCT(SalesTalks[ID]);
       SalesTalks[ID];
        ","
    ); 
USERELATIONSHIP(Slicer[Slicer Values];SalesTalks[SalesTalks])
)

Then you can use in a card or similar, you can also change the "," by the separator you prefer.

[Anonymous]

Thanks for the solution! Worked like a charme.

Best,

Jonas