Measure From a LookUpValue filtered by a Measure

Hi Anonymous ,

Please have a try.

Create a measure.

FiscalYearStartDate =
CALCULATE (
    MIN ( dateMapping[date] ),
    FILTER (
        ALL ( dateMapping ),
        dateMapping[FiscalYear] = SELECTEDVALUE ( dateMapping[FiscalYear] )
            && dateMapping[fiscal_day] = SELECTEDVALUE ( dateMapping[fiscal_day] )
    )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

Hi, thanks for getting back to me.

Unfortunately this didn't work, but I did manage to get what I want.

I deactived the relationships between these tables and it seems to have fixed it. This reaffirms my initial belief that the slicer was still filtering the dateMapping table even when it's wrapped in the "All" function.