Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |