Forum Discussion
Solved
Advanced filtering. Dependent dropdown using modelling
I have created a dim table filter which is modelled from 2 tables My query for this is - calcProjectNameFilter = DISTINCT(
UNION(
VALUES('Vani_Trends actual'[Project Name]),
VALUES...
Hi anansrivastava ,
Why you don't combine the phase name column and project column in a filter table?
Filter = DISTINCT( UNION( SELECTCOLUMNS('Vani_Trends actual',"Project Name",'Vani_Trends actual'[Project Name],"Phase Name",'Vani_Trends actual'[Phase Name]), SELECTCOLUMNS('Vani_Trends2 - planned',"Project Name",'Vani_Trends2 - planned'[Project Name],"Phase Name",'Vani_Trends2 - planned'[Phase Name]) ))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Dear Selimovd,
Thank you for your reply.
However, I need to use data modelling as my slicer has 2 filter 2 tables. So something like -
calcProjectNameFilter = CALCULATETABLE( DISTINCT(
UNION(
VALUES('Vani_Trends actual'[Project Name]),
VALUES('Vani_Trends2 - planned'[Project Name])
),
ALLSELECTED(calcProjectNameFilter)
))
This didn't work. How can I integrate your solution with mine?
Hi anansrivastava ,
Why you don't combine the phase name column and project column in a filter table?
Filter = DISTINCT(
UNION(
SELECTCOLUMNS('Vani_Trends actual',"Project Name",'Vani_Trends actual'[Project Name],"Phase Name",'Vani_Trends actual'[Phase Name]),
SELECTCOLUMNS('Vani_Trends2 - planned',"Project Name",'Vani_Trends2 - planned'[Project Name],"Phase Name",'Vani_Trends2 - planned'[Phase Name])
))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai