Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @irnm8dn,
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
Hi
Cretae a column to show the states for the matching records as shown below and create a slicer based on this column.
Slicer State = IF ( Table1[CustomerID]=Table2[CustomerID], Table1[State])
Thanks
Raj
@Anonymous
Can you help me define the State with a DAX Statement.
Something to the effect:
If Customer ID in Table A is found in Customer ID in Table B then True, else False
** Table A has a unique instance of Customer IDs, Table B has repeating instances of Customer ID.
Thanks.
Hi @irnm8dn,
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
Hi @irnm8dn,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |