Forum Discussion
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...
Hi,
Create a third table with a single column which lists down all unique ID's from both tables. Create a relationship between from the ID column of both tables to the newly created third table. To your visual, drag ID from the third table. Write this measures:
Measure = sum(Prices[Price])
Hope this helps.