Forum Discussion

leudyston's avatar
leudyston
Helper I
8 years ago
Solved

Remove Negative Values ​​with Calculate

Hello friends, I need to create a measure that can only bring the positive values ​​of an expression and that the total of this measure is also calculated only by adding the positive values, I have t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this revised measure

     

    =if(HASONEVALUE(ditens[Tamanho]),IF([Calc Sugestão de Compras]>=0,[Calc Sugestão de Compras],0),SUMX(SUMMARIZE(VALUES(ditens[Tamanho]),[Tamanho],"ABCD",IF([Calc Sugestão de Compras]>=0,[Calc Sugestão de Compras],0)),[ABCD]))

     

    Hope this helps.

     

leudyston's avatar
leudyston
Helper I
8 years ago

Okay, I discovered the problem, as far as CALC SUGESTÃO COMPRAS, the ESTOQUE ATUAL measure that is part of the measures that generate the CALC SUGESTÃO COMPRAS is with filters wrong, so the solution you gave me is very correct.

Thank you so much!!

Merry Christmas!!

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

You are welcome.

  • leudyston's avatar
    leudyston
    Helper I
    8 years ago

    Hello Ashish_Mathur

     

    After fixing the error in the ESTOQUE ATUAL, continue with other validations and encountered this problem. When the context brings the result by Store, it is adding the negative value with the positive, giving divergence in the final value of the measure. Affecting the value per line of the measure SUGESTÃO DE COMPRAS.

     

    Can you help me find this problem as you created it?

     

    As this error only appeared when I was validating another store, I had to add its moves in the .pbix file, then follow the updated file link with store 33 MESSEJANA.

    FILE .PBIX

     

     

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    I cannot appreciate the problem - it is simply because of the language.  I may not be able to help.