Forum Discussion

dgenatossio's avatar
dgenatossio
Frequent Visitor
8 years ago

Sum the Values in Table B IF Table A Meets Criteria

I have 3 tables. One is a table with employee IDs (Table 'ID'). One is a table with employee IDs and their 2017 sales for one business (Table 'A'). The third table has employee IDs and their 2017 sal...
Need Help
dgenatossio's avatar
dgenatossio
Frequent Visitor
8 years ago

Jimmy, the 'Related' function does not show the column 'sales' from table A - there is no direct connection between A and B, they are both connected to 'ID'.

 

Any work around?

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi dgenatossio,

 

In dax, many side can't be used to filter one side between two tables, you should change the table structures.

 

Regards,

Jimmy Tao