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.
Could anyone tell me is this scheme is correct? I know that there are loops in this scheme but is it possible to work good?
Thanks for answers.
Solved! Go to Solution.
Hi @Anonymous ,
You can delete the two relationships in the red box, then set the Cross filter direction from Single to Both, which will treat the these tables as a single table . You can learn more : Create and manage relationships in Power BI Desktop .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi @Anonymous ,
You can delete the two relationships in the red box, then set the Cross filter direction from Single to Both, which will treat the these tables as a single table . You can learn more : Create and manage relationships in Power BI Desktop .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for answer 🙂
Hi,
All depends what do you want achived. This structure is hmm 'too nice' :). I wiem o czym piszesz. (sorry guys for local 🙂 )
Data in tables in your model are 'mixed'. I mean in same table you have customer's and pieces data. I can't see 'Calendar' table in your scheme, and a few more 'basic' tables.
But to give you correct answer first we have to understand data and goal.
Pozdrawiam
Adam
Dziękia Adam za odpowiedź. 🙂
Pozdrawiam.
WMac23,
No problem.
Please take a look on structure of relations in my data model. It's why for me your structure looks 'to simple' 🙂 I admit, your data don't have to be so complicated as mine, but as I said - firstly we have to understand source data and purpose of the report. If you need more assistance, please do not hesitate to contact me 🙂
Regards,
Adam
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |