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
I want to filter values "2024" and "FFR", so i write a measure and the put this on filter panel
I wrote thise measure
it returns me this error
"
Solved! Go to Solution.
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
3\Result
Best Regards,
Bof
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
3\Result
Best Regards,
Bof
filter is supposed to return a table... maybe wrap it in a countrows and check if >0?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.