Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
v-bofeng-msft
Community Support
Community Support

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

vbofengmsft_3-1725592420263.png

 

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

vbofengmsft_4-1725592458839.png

 

Best Regards,

Bof

 

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

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

vbofengmsft_3-1725592420263.png

 

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

vbofengmsft_4-1725592458839.png

 

Best Regards,

Bof

 

 

PowerNewUser
Resolver I
Resolver I

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors