Forum Discussion
Exclude certain string values
Anonymous , Try like
CALCULATE([No of Emails], Filter( dim_wrapup , not( dim_wrapup[Wrap Up Group] in {"BO Action", "BO Support", "H&M CLUB" })) , filter( dim_brand, SEARCH("*Ar*",dim_brand[Brand],1,0) = 0 ) )
Check this too
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
Anonymous , Try like
CALCULATE([No of Emails], Filter( dim_wrapup , not( dim_wrapup[Wrap Up Group] in {"BO Action", "BO Support", "H&M CLUB" })) , filter( dim_brand, SEARCH("*Ar*",dim_brand[Brand],1,0) = 0 ) )
Check this too
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
amitchandak
Hi,Thanks for the reply!
Your solution was exactly what I was looking for. This actually made me understand so much more about DAX and how to think...DAX vs Qlik is very different in terms of logic in some cases and this helped me. I had a lot of cases were I needed to do filtering of this kind in some key metrics.
Have nice day!
BR Fredrik