Column Summary Ignoring Filters

Question

I've found a few posts on here loosly related but none really seem to apply to my model so here we go:&nbsp;I've got Two Tables. Let's call them Transactions and Prices. Their architecture is as follows&nbsp;----------TRANSACTIONS----------ID#&nbsp; &nbsp;|&nbsp; &nbsp;EntryDate&nbsp; &nbsp;|&nbsp; &nbsp;TYPEA43&nbsp; |&nbsp; &nbsp;8/14/2021&nbsp; &nbsp;|&nbsp; New BusinessA44&nbsp; |&nbsp; &nbsp;6/14/2021&nbsp; &nbsp;|&nbsp; Repeat BusinessA45&nbsp; |&nbsp; &nbsp;7/01/2021&nbsp; &nbsp;|&nbsp; Repeat BusinessA24&nbsp; |&nbsp; &nbsp;5/21/2021&nbsp; &nbsp;|&nbsp; New Business&nbsp;&nbsp;--------------------PRICES--------------------ID#&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;TRANSACTION-ID#&nbsp; &nbsp;|&nbsp; &nbsp;PRICEB4153135&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A43&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;100B4153133&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A44&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;500B4153187&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;200B4153145&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;100&nbsp;The common link is Transaction[ID#] to Prices[Transaction-ID#]No fields are measures and the are coming directly from an SQL database if that matters&nbsp;I have a visualization that shows the values&nbsp;Transaction[ID#] and&nbsp;Prices[Price] which correctly displays in this fashion.&nbsp;ID#&nbsp; &nbsp;|&nbsp; &nbsp;PriceA43&nbsp; |&nbsp; &nbsp;100A44&nbsp; |&nbsp; &nbsp;500A45&nbsp; |&nbsp; &nbsp;200A24&nbsp; |&nbsp; &nbsp;100Total&nbsp; &nbsp; &nbsp;900&nbsp;The problem is that when I apply any filter (I'm tyring to Filter Transactions[Type] and Transactions[EntryDate]), the rows are properly filtered however the total continues to show 900 as opposed to the filtered total.&nbsp;Any help woud be great!

greg_deckler · Answer

millercj&nbsp;I am not able to replicate the behavior. See attached PBIX file below signature.

millercj · Answer

Looks like chaning "Cross Filter" to "Both" is what made the difference

ashish_mathur · Answer

Hi,
Create a third table with a single column which lists down all unique ID's from both tables.&nbsp; Create a relationship between from the ID column of both tables to the newly created third table.&nbsp; To your visual, drag ID from the third table.&nbsp; Write this measures:
Measure = sum(Prices[Price])
Hope this helps.

v-yalanwu-msft · Answer

Hi,&nbsp;millercj&nbsp;;
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 WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft · Answer

Hi,&nbsp;millercj&nbsp;;
Is the above answer helpful to you? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Column Summary Ignoring Filters

5 Replies

Related content

Grouped summaries with conditional filtering

Make measure ignore specific filter

Power BI July 2026 Feature Summary

Ignore filter for a measure

How to ignore Filter