Forum Discussion
Filter data based on another visual table
Anonymous thanks. Is the relationship single or both cross filter direction? See if this post helps explain why that matters
https://radacad.com/one-dimension-filters-another-dimension-in-power-bi
For your example i suggest you create measures using USERELATIONSHIP instead of calculated tables. You'll need inactive relationships to make this work.
AllisonKennedy thanks for your response. I created several calculated tables because there are different date columns in my raw data set. Basically, I had to group new measures by settlement start date and group expire measures by settlement end date.
So for table A, the DAX looks like:
CALCULATETABLE(SUMMARIZE(RAW DATA,
RAW DATA[Settlement End Date],RAW DATA[Account CSN],"Expire",SUM(RAW DATA[Expire]))
Table B:
CALCULATETABLE(SUMMARIZE(RAW DATA,
RAW DATA[Settlement Start Date],RAW DATA[Account CSN],"New",SUM(RAW DATA[New]))
The data model relationship is quite simple, there's only one Account CSN (unique value) table to connect them all. Happy to provide more information or perhaps a sample pbix file if this is still not clear enough.