Forum Discussion
hideakisuzuki01
Helper II
Helper IIALL 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])
hnguy71
Super User
Super Userhideakisuzuki01 , 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])