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

[Anonymous]

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

Client feedback	L3 Date
done	2021-01-16
fine	2020-11-28
	2020-10-05
	2021-01-16
good	2020-10-05
	2020-09-16

Required for Dax : 

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

Please help me to create correct DAX for above scenario.

[amitchandak]

@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 · Accepted solution]

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])))

[amitchandak]

@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]

Still facing issue count miss match 

[Anonymous]

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))