Forum Discussion
Solved
ALL function in virtual table is not removing duplicates
Hi, I cannot seem to figure out this so I need help. I have this simple table. Order Number Qty UnitPrice Sales A 1 80 80 B 1 80 80 C 3 200 600 D 3 200 600 E 5 4...
hideakisuzuki01 , hehehe, the ALL function kinda doesn't work like that.
Try this as a measure instead:
@Sales = VAR _Expression = FILTER(SUMMARIZECOLUMNS(Sales[Qty], Sales[UnitPrice]), Sales[Qty] * Sales[UnitPrice] >= 100) RETURN SUMX(_Expression, [Qty] * [UnitPrice])
The first ALL() returns a physical table, as you see; whereas the second ALL() is embedded in FILTER() and FILTER() returns a filter for CALCULATE(). That's to say, any rows pass through the filter will be used for calculation.