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 All,
I am very new (just 3 days use!) to Power BI, so I am sure I am missing something obvious and apologies if I am.
I have created a simple test environment in Power Pivot using live company data from the ERP database and then a budget table.
I have also created 2 further tables, one with detail of sales reps, one with Year/Month detail.
In Power Pivot, the 4 relationships between these 4 tables work without issue and I am able to extract a pivot by Rep/Year/Month comparing budget to actual, but replicating the measures and relationships in Power BI throws out a relationship activation error. I am completely at a loss as to why everything works with one but not the other.
Any thoughts?
Solved! Go to Solution.
Problem solved. Amending Cross Filter Direction from 'Both' to 'Single' did the trick! Not sure why, but I am sure the more I dig into this application the clearer it will become!
Problem solved. Amending Cross Filter Direction from 'Both' to 'Single' did the trick! Not sure why, but I am sure the more I dig into this application the clearer it will become!
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |