Calc from Disconnected table

[paivers]

I have a disconnected unrelated date dim table I am using as a disconnected slicer. In my fact table I want to calculate some things based upon a date range from that slicer (the items with dates belong in a related table, but this table doesn't even have dates to relate to. So I have a measure on this fact table that says EarliestIntervention:=min(InterventionDate[iDate]). That works fine, when I select a year, it shows Jan 1 of the selected year. The problem is I want to reference that measure in the rows of the fact table, and when I do that it always shows the first date in the dim regardless of what is selected. I have tried a few calculated field formulas such as =[EarliestIntervention]
=calculate(min(InterventionDate[iDate]),AllSelected(InterventionDate))
=minx(filter(AllSelected(InterventionDate),true=true),InterventionDate[iDate])
None of these work. Ideally rather than the result be a calculated column, I'd like this to be a measure, but that introduces another issue where I need a row context to be able to pull in a column to calculate with. Any ideas on the cleanest approach here?

 

[powerpivotpro]

Calc columns never recalc in response to slicer selections (or ANY activity in the pivot), so when you reference a measure in a calc column, the measure is ALWAYS evaluated as a grand total.

Sounds like you need an "all measure" solution that doesn't involve calc columns at all, but I don't understand your scenario well enough to offer any advice.

 

[paivers]

Thanks Rob. I did do some thinking about it and ended up adding a field to the fact table with the slicer value (increasing the rows, but a small table), and connecting in the disconnected slicer. That way I could write measures that would respect the selected rows.