Power Query M calculated column countif - minus - count blanks

[MasterSonic]

Hi guys

I am looking for a help with creating column based on this logic:

count rows where values is not "Day" minus count of blank values 

Could you help me with that please.

[amitchandak · Accepted solution]

@MasterSonic , Try a dax calculated column of measure

countx(filter(Table, Table[value]<> "Day"), Table[value]) - countrow(filter(Table, isblank(Table[Value])))