Maximum date from minimum date (measure)

[PKPK90]

Hi, I am trying to create measure that will return Maximum date from another measure.

First measure is in Site, Group, Item level

Second, should be on Site, item level only.

First measure is calculating first available date. Second shoould return max from MinAvailableDate_WC for Site Item.

result for second measure should be 2/5/2024 for 0000-214692-02 and 2/12/2024 for A110-20003-01

MinAvailableDate_WC =

VAR __DS0Core =

    ADDCOLUMNS(

        SUMMARIZE(

            'Calendar',

            'Calendar'[Site],

            'Calendar'[WorkCenterDescription],

            'New_CapacityTable'[Date],

            "M_RunningSub_Balance5", '_Measures'[M_RunningSub-Balance5]

        ),

        "TotalCapacity", CALCULATE(MAX('New_CapacityTable'[TotalCapacity]))

    )

VAR FilteredDS0Core =

    FILTER(

        __DS0Core,

        '_Measures'[M_RunningSub-Balance5] >= [TotalCapacity]

    )

VAR MinDateWithCapacityExceededScalar =

    MINX(FilteredDS0Core, 'New_CapacityTable'[Date])

RETURN

    MinDateWithCapacityExceededScalar

[lbendlin]

You cannot measure a measure.  Implement your business logic from scratch.