1. I try to do simple count if text_date (text format) is the same as a variable Max_Date (Date format). When I convert them both with num() in the table and I compare them than it gives correct results. But when I want to have a KPI with count based on this condition it's not filtering at all:
=Count({<"=num(date(date#(text_date,'DD/MM/YYYY')))" = {"=Num(Max_Date)"}>}distinct [mvp])
Max_Date formula:
=Date(Max(num(date(date#(text_date,'DD/MM/YYYY')))))
2. Additionally if I change text_date in filters I get different value for Max_Date. I've read that you have to put {1} in the formula but I don't know where.