Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi Guys
Any easier way to filter multi value in the same column in dax? I have more than 20 values that consist of %CSH% and %CRT% which i want to filter out. Currently I'm using Calculate(Count)). Below is an example of what i did.
FILTER(TableA,TableA[ColumnA] <> "%CSH%"),FILTER(TableA,TableA[ColumnA] <> "%CRT%"))
Solved! Go to Solution.
Hi @Anonymous ,
You could try to add filter condition like this: && NOT ( 'Table'[Column] IN { 1000005,1000006,1000007 } )
My sample:
Measure 2 =
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER ( 'Table', NOT ( 'Table'[Product] IN { "Paseo", "Velo", "VTT" } ) )
)
@Anonymous , You need to use search find or containsstring
Like
FILTER(TableA,search("CSH",TableA[ColumnA],,0)<=0 && search("CRT",TableA[ColumnA],,0)<=0)
Here =0 means it does not have that string
Thank you! I have another question. in SQL where they have where in and NOT IN operator, how can dax be applied? if I want to exclude below 1000005,1000006,1000007 in my filter. Appreciate your help!
Thanks! I have another question. in SQL where have where IN and NOT IN operator, how can it apply it dax? if i want to exclude below 1000005,1000006,1000007 in my filter. Appreciate your help!
Thanks! I have another question. in SQL they have where IN and NOT IN operator, how can we apply it in dax? if I want to exclude below 1000005,1000006,1000007 in my filter. Appreciate your help!
** Sorry for the previous message typo.
Hi @Anonymous ,
You could try to add filter condition like this: && NOT ( 'Table'[Column] IN { 1000005,1000006,1000007 } )
My sample:
Measure 2 =
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER ( 'Table', NOT ( 'Table'[Product] IN { "Paseo", "Velo", "VTT" } ) )
)
Hi XueDing,
Thanks alot! Cheers!
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |