The Comparison Table
From this table the user will select 1 Project and 1 Project_Plan to compare it to
The Project Table
The Project_Plan Table
Result I'm looking for:
Project filtered to: Project_B_2021
Project Plan filtered to: Project_Plan_B_2020
Note: I don't want to display output until the Project and Project Plan have not been selected
The joins in this relationship are:
'Project' table to 'Comparison' table using 'Project_ID'
'Project_Plan' table to 'Comparison' table using 'Project_Plan_ID'
'Project' table to 'Project_Plan' table using 'Activity_Name'
Can anyone tell me how to do this? Everything I've tried so far does not work.
Go to Solution.
Hi @james_andrade ,
Based on your description, you could do some steps as follows.
1. create a relationship between "The Project Table" and "The Project_Plan Table" and make it active
2. create two measures
MAX ( 'Project'[Actual] ),
FILTER ( 'Project', [Project_ID] = SELECTEDVALUE ( Comparison[Project_ID] ) )
MAX ( 'Project_Plan'[Planned] ),
[Project_Plan_ID] = SELECTEDVALUE ( Comparison[Project_Plan_ID] )
3. create a table visual.
Hope that's what you were looking for.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
My test result is here.
Due to the one-to-many relationship between "Project_ID" and "Project_Plan_ID", this result will occur if only the relationships are established in three tables.
Do you just want to display the output?
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.