Forum Discussion
millercj
5 years agoRegular Visitor
Column Summary Ignoring Filters
I've found a few posts on here loosly related but none really seem to apply to my model so here we go: I've got Two Tables. Let's call them Transactions and Prices. Their architecture is as follo...
v-yalanwu-msft
5 years agoCommunity Support
Hi, millercj ;
According to your description, I tested it. First of all, I confirmed that the two tables are in Directquery mode. Secondly, if the two tables are not related, it will not work. There must be a relationship. The filtering direction is best to be bidirectional, as follows:
The final output is shown below:
If it still does not solve your problem, can you share more scenes or information about your table?
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.