Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 ?
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |