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.
Hi, I want to filter value NOT CONTAINS the specified value but its not working
Mismatch Executive =
CALCULATE( COUNTROWS('table'),
FILTER(
'table',
('table'[Position Assignment Category] = "Permanent ~ Executive" ||
'table'[Position Assignment Category] = "Int. Secondee PET ~ Executive")
&& ('table'[Job Grade] <> BLANK()) &&
( NOT (
CONTAINS ( 'table','table'[Job Grade], "P1" )
|| CONTAINS ( 'table','table'[Job Grade], "P2" )
|| CONTAINS ( 'table','table'[Job Grade], "P3" )
))
)
)+0
can you help me?
Solved! Go to Solution.
Hi, @zahidah_mabd
Please try formula as below:
Mismatch Executive =
CALCULATE (
COUNTROWS ( 'table' ),
FILTER (
'table',
( 'table'[Position Assignment Category] = "Permanent ~ Executive"
|| 'table'[Position Assignment Category] = "Int. Secondee PET ~ Executive" )
&& ( 'table'[Job Grade] <> BLANK () )
&& ( NOT ( 'table'[Job Grade] IN { "P1", "P2", "P3" } ) )
)
) + 0
Best Regards,
Community Support Team _ Eason
Can I use CONTAINS instead of CONTAINSSTRING?
Hi, @zahidah_mabd
Please try formula as below:
Mismatch Executive =
CALCULATE (
COUNTROWS ( 'table' ),
FILTER (
'table',
( 'table'[Position Assignment Category] = "Permanent ~ Executive"
|| 'table'[Position Assignment Category] = "Int. Secondee PET ~ Executive" )
&& ( 'table'[Job Grade] <> BLANK () )
&& ( NOT ( 'table'[Job Grade] IN { "P1", "P2", "P3" } ) )
)
) + 0
Best Regards,
Community Support Team _ Eason
@zahidah_mabd , Try like
Mismatch Executive =
CALCULATE( COUNTROWS('table'),
FILTER(
'table',
('table'[Position Assignment Category] = "Permanent ~ Executive" ||
'table'[Position Assignment Category] = "Int. Secondee PET ~ Executive")
&& not(Isblank('table'[Job Grade] )) &&
( NOT (
CONTAINSSTRING ( 'table','table'[Job Grade], "P1" )
|| CONTAINSSTRING ( 'table','table'[Job Grade], "P2" )
|| CONTAINSSTRING ( 'table','table'[Job Grade], "P3" )
))
)
)+0
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |