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.
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('Vani_Trends2 - planned'[Project Name])
)
)
I now want to create a second filter - phase name that lets me filter the graphs. However, when I do the same process as above, it shows me all the phases but I want to show just the ones in a particular project.
How can I create a filter modelled from two tables AND dependent on the selected project name?
Solved! Go to Solution.
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
Hey @anansrivastava ,
you have to filter then the values that you are using. So try the following for your table:
FILTER(VALUES('Vani_Trends actual'[Project Name]), 'Vani_Trends actual'[Project Name]='myFavouriteProject')
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
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |