Forum Discussion

Sean-OReilly's avatar
Sean-OReilly
Icon for Helper IV rankHelper IV
4 years ago
Solved

Need 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, Cu...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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's avatar
technolog
Icon for Super User rankSuper User
4 years ago

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