Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone
Here is my problem. I have a table (LDM LIVE) with a summary,labels and description columns with a slicer (Part number) from another table (EPICOR LIVE). I need to find if the slicer value is found in the table summary.
If just one selected value in the slicer is one I have no problems. I use the following dax measure and then filter with those who have a value of 1
Solved! Go to Solution.
Hi @Anonymous
Please try
IsContained =
IF (
NOT ISEMPTY (
FILTER (
'LDM live',
NOT ISEMPTY (
FILTER (
ALLSELECTED ( 'EPICOR LIVE'[Part number] ),
CONTAINSSTRING ( 'LDM live'[Summary], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Description], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Labels], 'EPICOR LIVE'[Part number] )
)
)
)
),
1
)
@Anonymous
Please try
IsContained =
IF (
COUNTROWS ( ALLSELECTED ( 'EPICOR LIVE'[Part number] ) )
<> COUNTROWS ( ALL ( 'EPICOR LIVE'[Part number] ) ),
IF (
NOT ISEMPTY (
FILTER (
'LDM live',
NOT ISEMPTY (
FILTER (
ALLSELECTED ( 'EPICOR LIVE'[Part number] ),
CONTAINSSTRING ( 'LDM live'[Summary], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Description], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Labels], 'EPICOR LIVE'[Part number] )
)
)
)
),
1
)
)
@tamerj1 What if I don't want the table to show anything if nothing is selected in the slicer ?
@Anonymous
Please try
IsContained =
IF (
COUNTROWS ( ALLSELECTED ( 'EPICOR LIVE'[Part number] ) )
<> COUNTROWS ( ALL ( 'EPICOR LIVE'[Part number] ) ),
IF (
NOT ISEMPTY (
FILTER (
'LDM live',
NOT ISEMPTY (
FILTER (
ALLSELECTED ( 'EPICOR LIVE'[Part number] ),
CONTAINSSTRING ( 'LDM live'[Summary], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Description], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Labels], 'EPICOR LIVE'[Part number] )
)
)
)
),
1
)
)
Hi @Anonymous
Please try
IsContained =
IF (
NOT ISEMPTY (
FILTER (
'LDM live',
NOT ISEMPTY (
FILTER (
ALLSELECTED ( 'EPICOR LIVE'[Part number] ),
CONTAINSSTRING ( 'LDM live'[Summary], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Description], 'EPICOR LIVE'[Part number] )
|| CONTAINSSTRING ( 'LDM live'[Labels], 'EPICOR LIVE'[Part number] )
)
)
)
),
1
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |