Filter with measure

[userpien]

I want to filter values "2024" and "FFR", so i write a measure and the put this on filter panel

I wrote thise measure

FilterCamp = IF(FILTER(VALUES(M_Agg[CodZef]),M_Agg[CodZef]="2024"),1,0)

and it works

but if i write

FilterCamp = IF(FILTER(VALUES(M_Agg[CodZef]),M_Agg[CodZef]="FFR"),1,0)

it returns me this error
"

Cannot Convert value of type text to type true false"

why? i want to filter these two values, not only 2024

thanks

[v-bofeng-msft · Accepted solution]

Hi @userpien ,

Would you like to check if there are any rows in the M_Agg table where the CodZef value is equal to 2024 or FFR? If such rows exist, the measure will return 1; otherwise, it will return 0.

I’ve made a test and encountered the same issue you mentioned. You could try to use countrows instead as @PowerNewUser  mentioned, that is a good solution.

Here I have another idea in mind, and I would like to share it for reference.

1\My table

2\My measure

FilterCampFor2024 = If(IsBlank(CALCULATE(COUNT(M_Agg[CodZef]),M_Agg[CodZef]="2024")),0,1)

FilterCampForFFR = If(IsBlank(CALCULATE(COUNT(M_Agg[CodZef]),M_Agg[CodZef]="FFR")),0,1)

3\Result

Best Regards,

Bof

[PowerNewUser]

filter is supposed to return a table... maybe wrap it in a countrows and check if >0?