Forum Discussion
Visual Interactions Vs Filters in DAX
Hi prasaddn , Thank you for reaching out to the Microsoft Community Forum.
Yes, this is fundamentally a model issue, not a DAX issue. As long as PM exists only as part of a composite ID (PM + Account + Department), there is no real concept of a “PM at BU level”, so no amount of REMOVEFILTERS or ALL will ever give a correct population. PM must be a standalone dimension (one row per PM, with its own key) and the fact table should reference it via a proper key instead of a concatenated business ID. Once that is done, your original logic for BU-level vs filtered ranking will work naturally without complex DAX.
On further research I found the issue is with my model design and bridge tables used, like the ID column created. this is causing none of the remove() and keepfilters() work effectively. I will try to get my model fixed. Meanwhile if any other suggestions, please let me know.
Hi prasaddn , Thank you for reaching out to the Microsoft Community Forum.
Yes, this is fundamentally a model issue, not a DAX issue. As long as PM exists only as part of a composite ID (PM + Account + Department), there is no real concept of a “PM at BU level”, so no amount of REMOVEFILTERS or ALL will ever give a correct population. PM must be a standalone dimension (one row per PM, with its own key) and the fact table should reference it via a proper key instead of a concatenated business ID. Once that is done, your original logic for BU-level vs filtered ranking will work naturally without complex DAX.