Forum Discussion
Solved
Filter and Find
Could you explain how this filter works?
Var findVal = "MU"
RETURN
...some code..
FILTER (
'Table1',
FIND ( findVal, 'Table1'[ZU0_KOD], , 0 ) = 0
)
...
And how to change this if i need use multiple findVal values
findVal = {"MU", "DU", "DS"}
can i change it to?
Var findVal = {"MU", "DU", "DS"}
RETURN
...some code..
FILTER (
'Table1',
'Table1'[ZU0_KOD] NOT IN findVal
)
?
Analitika , at high level look like it should work
change like
Var findVal = {"MU", "DU", "DS"}
RETURN...some code..
FILTER (
'Table1',
NOT ('Table1'[ZU0_KOD] NOT IN findVal)
)
2 Replies
Analitika , at high level look like it should work
change like
Var findVal = {"MU", "DU", "DS"}
RETURN...some code..
FILTER (
'Table1',
NOT ('Table1'[ZU0_KOD] NOT IN findVal)
)But if need to take array from other measure
Measure = {"MU", "DU", "DS"}
Measure2 =
Var findVal = Measure
RETURN
...some code..
FILTER (
'Table1',
NOT ('Table1'[ZU0_KOD] NOT IN findVal)
)
