MAX Date per Material where Measure > 0

[Anonymous]

Hi, what I am trying to do is to get the maximum date by Material. I'm using datasets, tables with attributes, and tables with measures. 

DAX:

EVALUATE
SUMMARIZECOLUMNS (
    'Material'[MAT WRIN0],
    'Delivery Date'[DLVD Date],
    'Purchase Order'[PO Number],

    FILTER (
        VALUES ( 'Distributor'[DIST Country] ),
        ( 'Distributor'[DIST Country] = "Romania" )
    ),
    FILTER (
        VALUES ( 'Purchase Order'[PO Status Description] ),
        ( 'Purchase Order'[PO Status Description] = "Purchase order APPROVED" )
    ),

    "Purchase Order To Be Received Quantity", [Purchase Order To Be Received Quantity]
    )
ORDER BY 'Delivery Date'[DLVD Date]

Here is the data extract, and the final result should be like WRIN0 and Max DLVD Date (just one line per WRIN0).

[tamerj1 · Accepted solution]

Hi @Anonymous 

please use

EVALUATE
FILTER (
    SUMMARIZECOLUMNS (
        'Material'[MAT WRIN0],
        'Delivery Date'[DLVD Date],
        'Purchase Order'[PO Number],
        FILTER (
            VALUES ( 'Distributor'[DIST Country] ),
            ( 'Distributor'[DIST Country] = "Romania" )
        ),
        FILTER (
            VALUES ( 'Purchase Order'[PO Status Description] ),
            ( 'Purchase Order'[PO Status Description] = "Purchase order APPROVED" )
        ),
        "Purchase Order To Be Received Quantity", [Purchase Order To Be Received Quantity]
    ),
    'Delivery Date'[DLVD Date]
        = CALCULATE (
            MAX ( 'Delivery Date'[DLVD Date] ),
            ALLEXCEPT ( 'Material', 'Material'[MAT WRIN0] )
        )
)
ORDER BY 'Delivery Date'[DLVD Date]