Forum Discussion

marina_oliveira's avatar
marina_oliveira
Frequent Visitor
3 years ago
Solved

Table visualization totals

Hello everyone! I have a column that is the sum (subtraction) of two other columns (Disponível = Estoque - Pedidos). Sometimes, this subtraction is a negative number. My client wants to show zero in...
DAX
Table
total
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi marina_oliveira 
    You need to iterate over the matrials:

    Disponível (Correct Total) =
SUMX (
    VALUES ( 'Table'[Material] ),
    [Disponível]
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi marina_oliveira 
You need to iterate over the matrials:

Disponível (Correct Total) =
SUMX (
    VALUES ( 'Table'[Material] ),
    [Disponível]
)
  • marina_oliveira's avatar
    marina_oliveira
    Frequent Visitor
    3 years ago

    Thank you! it worked perfectly!