Creating Connection Between 2 Tables Based on Existing Column Condition

Question

Hi!&nbsp;&nbsp;Newer Power BI user here. I have two taables that I am trying to conncet. One table [Table 1] is a transaction level table, where each sale is a row, and each row has columns (product type, product subtype, total sale amount, city, state, zip, census tract, county, whether that county meets a certain threshold of poverty (poverty status) and comsumer (buyer) demographic infomation (gender,race,whether they live in low-income area)).&nbsp;In another table [table 2], I have a list of every county in the USA with the columns: state, county, and whether that county meets the poverty status threshold (Y/N binary data).&nbsp;&nbsp;In my visuals,&nbsp; it is showing totals of sales, but I am unable to show a visual of the total of sales in a county that meets the poverty threshold. I need to be able to use this filter on several visuals and can't find a solution online to help me create visuals from [Table 1] and being able to create visuals specific to the ones made in counties that meet the poverty status [Table 2]. I currently have a relationship 1:many in one direction ([Table 2] to [Table 1]).&nbsp;&nbsp;Thanks in advance to anyone able to decipher the dax code needed to get Table 1 to be filtered by the poverty status colum in Table 2.&nbsp;&nbsp;Any and all help would be appricated!&nbsp;&nbsp;

sahir_maharaj · Accepted Answer

Hello&nbsp;W2SANC&nbsp;&nbsp;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.

Forum Discussion

Creating Connection Between 2 Tables Based on Existing Column Condition

2 Replies

Related content

Creating connection to Warehouse

Create Gateway Connection - API

Create conditional measure

creating a lakehouse connection using service principal

Cannot create Notebook connection with Workspace Identity authentication