CALCULATETABLE Filter with && and ||

[DonalMc]

Hi,

I am trying to create a filter table with the below expression; however, I can't seem to use the highlighted || or element with the && and elements.

When I remove it, it returns a much smaller subset, when I leave it in it breaks the other filters.

Is ths a syntax issue of some kind?

2_Leads_Awareness = CALCULATETABLE('2_Leads', FILTER('2_Leads', '2_Leads'[Lead Status] <> "Disqualified" && '2_Leads'[Source Campaign Buyer's Journey] = "Awareness" && '2_Leads'[Lead Type] = "MQL" || '2_Leads'[Lead Type] = "Non-MQL"))

Thanks,

Donal

[Vvelarde · Accepted solution]

Hi @DonalMc

Try this:

2_Leads_Awareness =
CALCULATETABLE (
    '2_Leads',
    FILTER (
        '2_Leads',
        '2_Leads'[Lead Status] <> "Disqualified"
            && '2_Leads'[Source Campaign Buyer's Journey] = "Awareness"
            && '2_Leads'[Lead Type] IN { "MQL","Non-MQL"}
    )
)

Regards

Victor

Lima Peru

[DonalMc]

Lima Peru - Thank You!

[Anonymous]

I actually haven't used && and || at the same time so I'm not sure, but have you tried using brackets to better define your logic?