Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm working on a report with three different tables (Accounts, Users and Opportunities) pulled from SalesForce. I've created relationships between these tables with Cardinality as "Many to Many" and "Many to One".
I've created two tables with these datasets:
When I pull the data into "Table 1", I can see the data being listed, however, When I try to select a stage of the opportunity from the data with "#Opportunities" in Table 2 I'm not able to see the data being filtered.
Any help on this would be appreciated.
Hi @Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any confidential information. Please upload your files to One Drive and share the link here.
Why does your Accounts to Opportunities relationship come out many-to-many? Are there really single opportunities tied to multiple accounts? Aren't accounts unique? Could you remove duplicates in your accounts list? Obviously I would expect an account to potentially have multiple opportunities. Could you mock up some data?
Can you post an image of your model? Need to see directions of relationships, etc.
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |