Forum Discussion
Creating Connection Between 2 Tables Based on Existing Column Condition
Hello W2SANC
To filter the visual based on the poverty status, you can use a measure along with the RELATED function. The RELATED function allows you to access related columns from a table based on the established relationship:
Total Sales in Poverty Counties = CALCULATE( SUM('Table 1'[total sale amount]), RELATED('Table 2'[poverty status]) = "Y" )Do not hesitate to let me know if you might need further assistance.
Hello W2SANC
To filter the visual based on the poverty status, you can use a measure along with the RELATED function. The RELATED function allows you to access related columns from a table based on the established relationship:
Total Sales in Poverty Counties =
CALCULATE(
SUM('Table 1'[total sale amount]),
RELATED('Table 2'[poverty status]) = "Y"
)Do not hesitate to let me know if you might need further assistance.
Thanks, Sahir_Maharaj !
Your DAX related function makes sense and seems promising. But, when I go to type in the portion after "RELATED(" there is no drop down like there was for table 1 where I can select the table 2 [poverty status]. If I manually type it, it shows as an error, despite the connection I have between the two.
This is leading me to think I may be doing something wrong in the relationship.
Thanks!