Need Help re Filter vs Lookup Value

[Sean-OReilly]

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 ?

[v-zhangti · Accepted solution]

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.

[technolog]

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