Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
@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]))))