Filtering 2 columns

[setis]

Dear experts, 

I'd like to use NOT in the below measure in stead of making this workaround with the variable. I get the correct results, but I'd like to learn the correct filter. 

#Fees_NoAC_SL = 
VAR AC_SL =
CALCULATE([#Fees];
FILTER(Fees;
        Fees[Case Type] = "AC"
        && (Fees[ft_type] = "SL")))
RETURN
[#Fees] - AC_SL

Thanks in advance

[Mariusz · Accepted solution]

Hi @setis 

Try this.

#Fees_NoAC_SL = 
CALCULATE(
    [#Fees],
    FILTER(
        Fees,
        NOT( Fees[Case Type] = "AC" && Fees[ft_type] = "SL" )
    ) 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn