DAX filter

[askoflor]

hello, I wrote a DAX code to retrieve only the positive lines of my subtraction.
but there is a problem I am told to include a parameter in the ALLSELECTED(),

Positive Result =
CALCULATE (
[Sum Measure 1] - [Sum Measure 2],
FILTER (
ALLSELECTED ( ),
[Sum Measure 1] - [Sum Measure 2] > 0
)
)

THANKS

[BrianShaw · Accepted solution]

Yes you need to put a table name in between the ( ) so that it know what table you want all rows selected.