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)

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

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

     

     

2 Replies

  • PowerNewUser's avatar
    PowerNewUser
    Resolver I
    1 year ago

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

  • 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