Forum Discussion
Filter with measure
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) an...
Hi Anonymous ,
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
filter is supposed to return a table... maybe wrap it in a countrows and check if >0?