Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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