I need a little help with some DAX to always select a value from a child table no matter the filter context. I have simplified the problem to my core issue in excel. I have two tables.
I want a measure that will always return the Active value for the given OrderId. I have tried =CALCULATE(SUM([Value]), OrderVersions[Status]="Active") but this only provides the value when the filter context is Status=Active.
Any help would be appreciated.
Solved! Go to Solution.