Forum Discussion
Relationship Between 2 Tables - Slicer Management - Please Help!!!
I have two sets of data that have a relationship, joined by Customer ID. Because of the nature of how the data is sent to me, I would like to only show the data where records have a match. That is to say that the slicers only show the data of the records where the Customer ID is represented in both tables.
i.e. If I wanted to select the "State" from a slicer, the only states that would show would be those where a Customer ID is present in both tables...not a representation of all 50 states.
The actual visualizations work correctly, it is the slicers I am trying to limit.
Any suggestions?
Hi Anonymous,
Please check the formula as below to work on it.
Column = var rsult =LOOKUPVALUE(TableB[Customer ID],TableB[Customer ID],'Table A'[Customer ID]) return IF(ISBLANK(rsult),FALSE(),TRUE())
Also please find the file attached.
Regards,
Frank
4 Replies
Hi Anonymous,
Please check the formula as below to work on it.
Column = var rsult =LOOKUPVALUE(TableB[Customer ID],TableB[Customer ID],'Table A'[Customer ID]) return IF(ISBLANK(rsult),FALSE(),TRUE())
Also please find the file attached.
Regards,
Frank