Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a column 'a' with delimiter comma in a table A. I need to choose data based on the single value selected from the column with delimiter.
My approach is creating a B list/ table with distinct values from the column 'a' and then making a measure as
Selected=SELECTEDVALUE(B[b])
Now adding this measure to a table visual does not work in advanced filtering
Solved! Go to Solution.
Hi @Drake1002
Try this measure which can choose up to 3 values:
Measure 2 =
VAR _slicer = CONCATENATEX(
'Table B',
'Table B'[Column b]
)
RETURN
IF(
COUNT('Table B'[Column b]) = 1 && FIND(
MID(
_slicer,
1,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK(),
_slicer,
IF(
COUNT('Table B'[Column b]) = 2 && FIND(
MID(
_slicer,
1,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK() && FIND(
MID(
_slicer,
2,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK(),
_slicer,
IF(
COUNT('Table B'[Column b]) = 3 && FIND(
MID(
_slicer,
1,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK() && FIND(
MID(
_slicer,
2,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK() && FIND(
MID(
_slicer,
3,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK(),
_slicer
)
)
)
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Table A
Column a
A,B,X
A,V,B
B,C,G
B,H,R
M,A,C
Z,C,B
Table B
Column b
A
B
C
X
V
G
H
R
M
Z
If i select A in the slicer then output visual be
A,B,X
A,B,V
M,A,C
Hi @Drake1002
Please try this:
First of all, I add a measure:
MEASURE =
VAR _Slicer =
SELECTEDVALUE ( 'Table B'[Column b] )
RETURN
IF (
FIND ( _Slicer, SELECTEDVALUE ( 'Table A'[Column a] ),, BLANK () ) <> BLANK (),
_Slicer
)
Then create a table visual like this:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Zhengdong Xu. What if i want to select A and B both and it should display values having either A or B?
Hi @Drake1002
Try this measure which can choose up to 3 values:
Measure 2 =
VAR _slicer = CONCATENATEX(
'Table B',
'Table B'[Column b]
)
RETURN
IF(
COUNT('Table B'[Column b]) = 1 && FIND(
MID(
_slicer,
1,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK(),
_slicer,
IF(
COUNT('Table B'[Column b]) = 2 && FIND(
MID(
_slicer,
1,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK() && FIND(
MID(
_slicer,
2,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK(),
_slicer,
IF(
COUNT('Table B'[Column b]) = 3 && FIND(
MID(
_slicer,
1,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK() && FIND(
MID(
_slicer,
2,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK() && FIND(
MID(
_slicer,
3,
1
),
SELECTEDVALUE('Table A'[Column a]),
,
BLANK()
) <> BLANK(),
_slicer
)
)
)
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |