Key word filter for tables that can't be merged or linked

[dniedrauer]

Hi there, 

I am trying to create a filtered table that displays only the customer id that is selected by a filter on another table which I can't link due to data discrepancies. 

Calculated Table = calculate(distinct(Customer[Customer Id]),filter('Main',Main[Customer Id]=FIRSTNONBLANK(Customer[Customer Id],1))) returns an error. 

 

[v-ljerr-msft]

Hi @dniedrauer,

---

I am trying to create a filtered table that displays only the customer id that is selected by a filter on another table which I can't link due to data discrepancies.

---

Not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report. So it is not possible to create a calculate column/table can change dynamically with user selections on the report.

Could you try setting the cross filter direction to Both for both relationships(marked below) to see if it works in your scenario? 

Regards