How to create second filter

Hi RogueTrooper ,

According to your description, in your formula, in the FILTER function, you can only directly reference columns in the current table or other measures. When you enter a single quote, it automatically pops up which can only be quoted like below:

I create a sample.

MNSalesOrderLine table:

MNSalesOrderHdr table:

LastRefreshedDate table:

Modify the measure like this:

ALL OS VALUE PERIOD =
CALCULATE (
    SUM ( MNSalesOrderLine[OS LCY Value] ),
    USERELATIONSHIP ( MNSalesOrderHdr[No], MNSalesOrderLine[Document_No] ),
    FILTER (
        MNSalesOrderLine,
        MNSalesOrderLine[Shipment_Date]
            <= EOMONTH ( MAX ( LastRefreshedDate[DateLastRefreshed] ), 0 )
            && MAXX (
                FILTER (
                    'MNSalesOrderHdr',
                    'MNSalesOrderHdr'[No] = EARLIER ( 'MNSalesOrderLine'[Document_No] )
                ),
                'MNSalesOrderHdr'[Status]
            ) = "RELEASED"
    )
)

 Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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