Forum Discussion
stevedata
1 year agoFrequent Visitor
Connected tables problem
I have 3 target lists; each target list has company names. Some company names appear in multiple target lists target list A target list B target list C company 1 company 2...
- Anonymous1 year ago
Hi stevedata ,
Based on your description, first create the following relationships in these tablesCreate field parameter
Parameter = { ("target list A", NAMEOF('target list A'[target list A]), 0), ("target list B", NAMEOF('target list B'[target list B]), 1), ("target list C", NAMEOF('target list C'[target list C]), 2) }Create a mesure
Measure = SWITCH( TRUE(), SELECTEDVALUE(Parameter[Parameter Order]) = 0,IF(SELECTEDVALUE('target list A'[target list A]) = BLANK(),0,1), SELECTEDVALUE(Parameter[Parameter Order]) = 1,IF(SELECTEDVALUE('target list B'[target list B]) = BLANK(),0,1), SELECTEDVALUE(Parameter[Parameter Order]) = 2,IF(SELECTEDVALUE('target list C'[target list C]) = BLANK(),0,1) )Create a table visualization
Use the measure as the filter of the table visualization
Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous
1 year agoNot applicable
Hi stevedata ,
Based on your description, first create the following relationships in these tables
Create field parameter
Parameter = {
("target list A", NAMEOF('target list A'[target list A]), 0),
("target list B", NAMEOF('target list B'[target list B]), 1),
("target list C", NAMEOF('target list C'[target list C]), 2)
}
Create a mesure
Measure =
SWITCH(
TRUE(),
SELECTEDVALUE(Parameter[Parameter Order]) = 0,IF(SELECTEDVALUE('target list A'[target list A]) = BLANK(),0,1),
SELECTEDVALUE(Parameter[Parameter Order]) = 1,IF(SELECTEDVALUE('target list B'[target list B]) = BLANK(),0,1),
SELECTEDVALUE(Parameter[Parameter Order]) = 2,IF(SELECTEDVALUE('target list C'[target list C]) = BLANK(),0,1)
)
Create a table visualization
Use the measure as the filter of the table visualization
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly