Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
37 | |
21 |