Forum Discussion
askoflor
3 years agoNew Member
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
- BrianShawMicrosoft Employee
Yes you need to put a table name in between the ( ) so that it know what table you want all rows selected.