The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I have a problem in the relations between the different tables.
I want to display the correct values of two measures.
The first is calculated using a field in the rotationdocument table and the second is calculated using the product taskdetails table.
When using strattask (a field in the rotationdocument table) the visual displays the correct value of the first measure and a false value of the second measure.
First things first. Bidirectional filters and many-to-many relationships are poison to your data model. I'd suggest watching your Youtuber of choice on creating data model and managing relationships in Power Bi. My preferred source is Avi Singh. If you get this right, you'll run into a lot fewer problems in the future.
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
46 |