topic Re: Help to Create Dax: applying filter for both Data Type(Text and Date) in DAX Commands and Tips

Help to Create Dax: applying filter for both Data Type(Text and Date)

Anonymous — Tue, 22 Dec 2020 12:34:50 GMT

Hi All,

I'm struck to create DAX in keep filters,

Condition: we need to create 1 dax for satisfing for below 2 conditions

1. Date: L3 Date<Date(2020,12,31)

2.Client feedback : Is Blank

Required for Dax :

L3 Date<=dec 2020 31 && isblank( client feedback)

Please help me to create correct DAX for above scenario.

Anonymous — Tue, 22 Dec 2020 12:49:48 GMT

I tried like below mentioned DAX but no luck

L3 Amber =

SUMX('Status',

ISBLANK('Status'[CLient feedback]) || 'Status'[L3 Date].[Date]>=DATE(2020,12,31))

amitchandak — Tue, 22 Dec 2020 13:44:18 GMT

Anonymous , Try a measure formula like

calculate(count(Table[L3 Date]), filter(Table, isblank(Table[L3 Date]) || Table[L3 Date] <= date(2020,12,31)))

Anonymous — Tue, 22 Dec 2020 14:20:51 GMT

Still facing issue count miss match

amitchandak — Tue, 22 Dec 2020 14:47:39 GMT

Anonymous , Try like this. If does not match share expected output

calculate(count(Table[L3 Date]), filter(Table, isblank(Table[Client feedback]) || Table[L3 Date] <= date(2020,12,31)))

Anonymous — Wed, 23 Dec 2020 09:32:24 GMT

Hi Tried like this below mentioed DAX it's working fine

DAX:

L3 Feedback Blank= CALCULATE(count(Table[L3 Date]), filter(Table, Table[L3 Date] <= DATE(2020,12,31) && ISBLANK('Table'[Client feedbac])))