CREATING NEW calculated row

Hi Anonymous ,

We cannot create calculated row directly, please refer to my pbix file to see if it helps you.

Create three measures.

package =
VAR _all =
    SUMX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Product] >= 29.27
                && 'Table'[Product] <= 29.39
        ),
        'Table'[COGS (OM) packaging materials]
    )
RETURN
    IF (
        HASONEVALUE ( 'Table'[Product] ),
        MAX ( 'Table'[COGS (OM) packaging materials] ),
        _all
    )

purchased =
VAR _all =
    SUMX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Product] >= 29.27
                && 'Table'[Product] <= 29.39
        ),
        'Table'[COGS (purchased third party)]
    )
RETURN
    IF (
        HASONEVALUE ( 'Table'[Product] ),
        MAX ( 'Table'[COGS (purchased third party)] ),
        _all
    )

raw =
VAR _all =
    SUMX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Product] >= 29.27
                && 'Table'[Product] <= 29.39
        ),
        'Table'[COGS (OM) raw materials]
    )
RETURN
    IF (
        HASONEVALUE ( 'Table'[Product] ),
        MAX ( 'Table'[COGS (OM) raw materials] ),
        _all
    )

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.