Filter a column using another column values

[Anonymous]

Hi everyone,

i need to filter Column A based on Column B value, for example

i need to hide every ID VALUE that appears in  Reversal ID, what i expect is something like this result (the lines that appears the reversal id not blank i will hide by the SKU, thats ok)

my data

Thanks

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

Just use this measure to get it:

Measure = 
VAR _REVERSALID=CALCULATETABLE(VALUES(Planilha1[REVERSAL ID]),ALLSELECTED(Planilha1))
RETURN
CALCULATE(SUM(Planilha1[SKU]),FILTER(Planilha1,NOT(Planilha1[ID VALUE]) IN _REVERSALID && Planilha1[SKU]>0))

Result:

 Regards,

Lin

[amitchandak]

@Anonymous , Add a measure like this in the visual table and try

calculate(coutrows(Table), Filter(Table, not(table[ID] in values(Table[Reversal ID]))))

[Anonymous]

@amitchandak Thanks for your reply, unfortunately this measure didnt work