Forum Discussion

BAUTNIDE's avatar
BAUTNIDE
Regular Visitor
2 years ago
Solved

Add calculated row values ​​as a total

Hello dear Power BI community,   I have the following problem: I have calculated a number of boxes that need to be refilled for a process if the net required quantity is greater than 0. The calcula...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    BAUTNIDE , Try updated measure instead of MAX using SUMX

     

    DAX
    BedarfKLTs =
    SUMX(
    'Zusammenführen1',
    IFERROR(
    IF(
    'Zusammenführen1'[Nettobedarf Nachschub] / 'Zusammenführen1'[tbl_PACKSPEC.Menge] <= 0,
    0,
    ROUNDUP('Zusammenführen1'[Nettobedarf Nachschub] / 'Zusammenführen1'[tbl_PACKSPEC.Menge], 0)
    ),
    0
    )
    )

BAUTNIDE's avatar
BAUTNIDE
Regular Visitor
2 years ago

Wow, I´m very impressed 😀

It seems, that it´s working 👍

Thanks for the very quick reply