Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
84 | |
66 | |
49 |
User | Count |
---|---|
140 | |
114 | |
108 | |
64 | |
60 |