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.
Hi prasaddn
a picture of the data model qould help, you described it but visually it is easier to see it
Thanks
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi FBergamaschi ,
The model is quite huge and may confuse outsider.. I am sharing the limited view.
the vwu_process_compliance_data is connected with Master - Meta Data using ID column, which is concatenation :
ID = CONCATENATE(vwu_process_compliance_data[Sub Department New],CONCATENATE(vwu_process_compliance_data[Account STD],vwu_process_compliance_data[PM Email Id]))
And, I have the Master - Meta data a union table as follows:
Master - Meta Data =
DISTINCT (
UNION (
SELECTCOLUMNS (
SUMMARIZE (
Initiation,
Initiation[Sub department New],
Initiation[ID],
Initiation[Account STD],
Initiation[PM STD]
),
"SubDept Name", Initiation[Sub department New],
"ID", Initiation[ID],
"Account_Std", Initiation[Account STD],
"PM Name", Initiation[PM STD]
),
SELECTCOLUMNS (
SUMMARIZE (
vwu_process_compliance_data,
vwu_process_compliance_data[Sub Department New],
vwu_process_compliance_data[ID],
vwu_process_compliance_data[Account STD],
vwu_process_compliance_data[PM STD]
),
"SubDept Name", vwu_process_compliance_data[Sub Department New],
"ID", vwu_process_compliance_data[ID],
"Account_Std", vwu_process_compliance_data[Account STD],
"PM Name", vwu_process_compliance_data[PM STD]
),
SELECTCOLUMNS (
SUMMARIZE (
hr_master,
hr_master[Sub Department New],
hr_master[ID],
hr_master[Account_Std],
hr_master[PM STD]
),
"SubDept Name", hr_master[Sub Department New],
"ID", hr_master[ID],
"Account_Std", hr_master[Account_Std],
"PM Name", hr_master[PM STD]
)
)
)