Forum Discussion

leudyston's avatar
leudyston
Helper I
8 years ago
Solved

Remove measurement negative values

Hello friends,

 

I am having a problem in SUGESTÃO DE COMPRAS measurement When in my context only one store is being filtered, the measure works correctly not subtracting the negative values ​​and appearing zeroed. However, when filtering more than one store, as in the example below, the stores ALDEOTA and MESSEJANA, the measure subtracts the negative value of a store by the positive of another store, changing the TOTAL, but there should be no such subtraction, precisely because negative values were replaced by "0".

 

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

 

Can anyone help me with this problem?

 

I am making available the .pbix file and below the explanatory image.

file .PBIX

 

 

 

 

 

 

 

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    leudyston

     

    In this scenario, I don't think it's possible to control the sub total result with DAX. On each row level total, it still takes the slicer from ditens[Tamanho]. So it will always calculate all [Calc Sugestão de Compras] then apply the condition, the logic can never go to this part: 

     

    SUMX(
                              SUMMARIZE(
                                        VALUES(ditens[Tamanho]);
                                         [Tamanho];
                                         "AgrupaTamanho";
                                         IF(                                                                                                                             [Calc Sugestão de Compras]>=0;
                                            [Calc Sugestão de Compras];0
                                           )
                                         )
                               ;[AgrupaTamanho]
                              )

    Regards,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    leudyston

     

    In this scenario, I don't think it's possible to control the sub total result with DAX. On each row level total, it still takes the slicer from ditens[Tamanho]. So it will always calculate all [Calc Sugestão de Compras] then apply the condition, the logic can never go to this part: 

     

    SUMX(
                              SUMMARIZE(
                                        VALUES(ditens[Tamanho]);
                                         [Tamanho];
                                         "AgrupaTamanho";
                                         IF(                                                                                                                             [Calc Sugestão de Compras]>=0;
                                            [Calc Sugestão de Compras];0
                                           )
                                         )
                               ;[AgrupaTamanho]
                              )

    Regards,