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.
In the star schema shown below, it was possible to make one of the fact tables bidirectional in order to link the fact tables without the key of the master table. However, as the number of data and parameters increases, the calculation of the Power BI measure becomes very heavy. I would like to know how to deal with this problem.
thank you very much.
Solved! Go to Solution.
@Anonymous , bi- directional join means if any filter that impacts fact will also recalculate dimension values on use on-page.
This means all slicers will be filtered based on any change.
refer if needed
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
@Anonymous , bi- directional join means if any filter that impacts fact will also recalculate dimension values on use on-page.
This means all slicers will be filtered based on any change.
refer if needed
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
I understand. It is unavoidable that the filters between these fact tables become heavy.
Thank you for answering.
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 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |