Forum Discussion

askoflor's avatar
askoflor
New Member
3 years ago
Solved

DAX filter

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

 

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

1 Reply

  • BrianShaw's avatar
    BrianShaw
    Microsoft Employee

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