Forum Discussion

Piinherio's avatar
Piinherio
Frequent Visitor
3 years ago

Merge cell that have same value

Hi, I have two different PO Number as shown, each one has a different qty, I made a colmun that sums both, but I want to the total of both POs to be shown in one cell; as merged cell or so. is this ...
Need Help
Arul's avatar
Arul
Super User
3 years ago

Piinherio ,

Do you still need P.O Number in your visual?

Thanks,

Arul

 

  • Piinherio's avatar
    Piinherio
    Frequent Visitor
    3 years ago

    Yes, it should remain in the visual. 

    • Arul's avatar
      Arul
      Super User
      3 years ago

      Piinherio ,

      try this measure,

      Sum of QTY = CALCULATE(
    SUM('Table '[Quantity]),
    ALL('Table '))

      Thanks,

      Arul