Forum Discussion

BLM's avatar
BLM
Helper I
8 years ago
Solved

Table total error

hello,   i've maked a table with several measures. Specifically the measure "afabricar" don't want that show negatives values (if the result it's negative the valued must be zero). Well, if the me...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi BLM,

     

    Try this formula, please. If it still doesn't work, please share your file or a dummy sample.

    afabricar =
VAR temp =
    IF (
        SUM ( Productos[smincorregido] ) = 0;
        [sminnew];
        SUM ( Productos[smincorregido] )
    )
        - [stockactual]
        + IF ( [totalconsumos] < [sminnew]; [sminnew]; [totalconsumos] )
        - 'ops+stocks+cargas'[opspdts]
RETURN
    IF (
        HASONEVALUE ( 'TableName'[codnombre] );
        IF ( temp < 0; 0; temp );
        SUMX (
            SUMMARIZE (
                'TableName';
                'TableName'[codnombre];
                "temp1"; IF (
                    SUM ( Productos[smincorregido] ) = 0;
                    [sminnew];
                    SUM ( Productos[smincorregido] )
                )
                    - [stockactual]
                    + IF ( [totalconsumos] < [sminnew]; [sminnew]; [totalconsumos] )
                    - 'ops+stocks+cargas'[opspdts]
            );
            [temp1]
        )
    )

    Best Regards,

    Dale

PaulDBrown's avatar
PaulDBrown
Community Champion
8 years ago

BLM

 

I understand your measure [afabricar] returns negative values as '0', and positive values stay the same, right? 

 

Try using:

 

Correct totals for afabricar = SUMX(SUMMARIZE('tableforcodnombre', 'tableforcodnombre'[codnombre]), [afabricar])

 

(where 'tableforcodnombre' is obviously the lookup table where your 'codnombre' column is; if you don't have a lookup table for codnombre, you'll have to wrap it in VALUES)