Forum Discussion
Solved
Dax Filter / Search vs Visualisation Filter Values
Hi all, i have a dashboard which uses a tba;e called "Combined". I have a card on the dashboard which uses the dax code below to count where the "XXXX Status" column has the value "Closed" - ...
The SEARCH function is including those rows with a status of "Not Closed" as well as "Closed". Rather than using SEARCH just use a straight =, e.g. 'Combined'[XXXX Status] = "Closed".
The SEARCH function is including those rows with a status of "Not Closed" as well as "Closed". Rather than using SEARCH just use a straight =, e.g. 'Combined'[XXXX Status] = "Closed".