Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi everyone,
Fairly basic PowerBI user here, apologies if my question is perfectly formatted.
I have the following data:
Accounts
ID | Name |
1 | Contoso |
Assets
Account_ID | Product_Line_ID |
1 | 1 |
Product Line
ID | Name |
1 | Star_Product |
In my report I need to be able to filter the accounts based on if they have any products from our Star_Product line.
I was thinking that I could add a HasStar_Product field as a Boolean to my accounts table and then I could filter the page in my report by that Boolean but I can't work out the best way to do it, any guidance or assistance would be greatly appreciated.
Cheers,
Coops
filter(accounts,calculate(count(productline[id]),productline[name]="start_product"))
Hi Daniel,
Thanks for your response, I assumed that it should have been product then product line.
This is the error I received, any chance of another pointer please ?