Forum Discussion

New Member

4 years ago

Solved

Create calculated table by filtering a table based on other table's column value

I am a newbie in power bi. I wanted to create a calculated table which will return all values from table 1 filtered based on table2[column].

Community Support

4 years ago

Hi， sinha

Please try calculated table as below:

NEW Table = CALCULATETABLE(Table1,Table1[Column] IN VALUES(Table2[Column]))

Best Regards,
Community Support Team _ Eason