Forum Discussion
Helper IVNeed Help re Filter vs Lookup Value
Hi
I have two Tables Links and the Common Key = ID and Parent ID.
One of the tables = Vendors and the Other Table = Dimensions. The dimensions tables holds various dimensions values for Vendors, Customers, Resources, Employees etc.
When i pull in a Table Visual against my Vendors i get the below.
You will note that it shows blank lines for all of the Dimension Values that are not contained in the Vendor Table.
I thought that the table visual would only show entries that are contained in the Vendor Table.
I want to remove these Blanks. What is the best way of doing this ?
Hi, Sean-OReilly
I briefly simulated some data that I hope fits your situation.
Measure:
Measure = IF(SELECTEDVALUE(Table1[ID])<>BLANK(),1,0)Put Measure in the filter and set it to equal 1.
Does this match the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- technolog
Super User
You could create calculation table with column from both tables and then add calculation column
IF ( ISBLANK([id]), "BLANK ID NAME", [id])
and after that visualize this table
v-zhangtiCommunity Support
Hi, Sean-OReilly
I briefly simulated some data that I hope fits your situation.
Measure:
Measure = IF(SELECTEDVALUE(Table1[ID])<>BLANK(),1,0)Put Measure in the filter and set it to equal 1.
Does this match the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
