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 possbile in power BI?

 

Need Help

3 Replies

      • Arul's avatar
        Arul
        Super User
        3 years ago

        Piinherio ,

        try this measure,

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

        Thanks,

        Arul