Forum Discussion
Sean-OReilly
Helper IV
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, Cu...
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.
v-zhangti
Community Support
Community SupportHi, 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.