Forum Discussion
Multiple Combination selection using Slicer
- Anonymous2 years ago
Hi Sudharshan1919 ,
Please try below steps:
1. create a measure with below dax formula
Measure = VAR cur_lname = SELECTEDVALUE ( 'Table B'[ListName] ) VAR cur_aname = SELECTEDVALUE ( 'Table A'[AgentsName] ) VAR _val = IF ( CONTAINSSTRING ( cur_aname, cur_lname ), 1 ) RETURN IF ( NOT ( ISFILTERED ( 'Table B'[ListName] ) ), 1, _val )2. add a table visual with Table A fields, add a sclicer with Table B [ListName], add the measure to the table visual filter pan and set
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Sudharshan1919 ,
Please try below steps:
1. create a measure with below dax formula
Measure =
VAR cur_lname =
SELECTEDVALUE ( 'Table B'[ListName] )
VAR cur_aname =
SELECTEDVALUE ( 'Table A'[AgentsName] )
VAR _val =
IF ( CONTAINSSTRING ( cur_aname, cur_lname ), 1 )
RETURN
IF ( NOT ( ISFILTERED ( 'Table B'[ListName] ) ), 1, _val )
2. add a table visual with Table A fields, add a sclicer with Table B [ListName], add the measure to the table visual filter pan and set
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.