Need Help with a Measure

Potential issue with the 'Measure 6' formula is related to the filter context of the 'Plan Type' column. When you use the ALL function on the 'Plan Type' column, it removes the filter context of that column, which is causing the same value to appear in every row of the 'Measure 6' column.

To fix this issue, you can use the VALUES function to get a table of distinct values in the 'Plan Type' column and iterate over them using the SUMX function. Here is an updated formula that should work:

Measure 6 =
SUMX (
    VALUES ( 'Worker Compensation Detail All'[PLAN TYPE] ),
    CALCULATE (
        SUM ( 'Worker Compensation Detail All'[PAY RATE_] ),
        FILTER (
            ALL ( 'Worker Compensation Detail All'[PLAN TYPE] ),
            'Worker Compensation Detail All'[Date Key] = MAX ( 'Worker Compensation Detail All'[Date Key] )
        )
    )
)

I hope I am understanding your issue correctly and hope this helps