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?
=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?