Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter a column using another column values

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 line...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

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