Forum Discussion

Olenard's avatar
Olenard
Helper III
5 years ago
Solved

Function sign

Dear power Bi community   i am trying to use the command sign. But the results is strange. Please see below :     I excpected the results to be -1 on negative lines.   Thank you all
DAX
  • Anonymous's avatar
    Anonymous
    5 years ago

    Olenard

    If you use SUM(...) when you have a row context, the SUM does not see any row context since it's an aggregator and only works with filter contexts. So, SUM sees ALL ROWS at the same time. Please remove SUM from the formula and it'll then work row by row. Please learn about contexts and how they behave.

     

    By the way, SIGN does NOT need a measure: https://dax.guide/sign/

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Olenard

If you use SUM(...) when you have a row context, the SUM does not see any row context since it's an aggregator and only works with filter contexts. So, SUM sees ALL ROWS at the same time. Please remove SUM from the formula and it'll then work row by row. Please learn about contexts and how they behave.

 

By the way, SIGN does NOT need a measure: https://dax.guide/sign/

  • Olenard's avatar
    Olenard
    Helper III
    5 years ago

    Hi Anonymous ,
    I think I get it. Should I use Sumx then ?