Forum Discussion

wiktor_nus's avatar
wiktor_nus
Regular Visitor
4 years ago

ffilter two tables

Hello, I would like to filter two tables in the report, the tables have no relationship. In both tables there is a "date" field and I would like to put a filter on that it also affects the other tabl...
Need Help
Tips and Tricks
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, wiktor_nus ;

You could try it.

 

measure=calculate(Sum(Table1[Value]), filter(Table1, Table1[Date] in allselected(Table2[Date]) ) )

 

Or Can you post sample data as text and expected output?

The best way is create a measure to contorl two table without relationship.

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.