Forum Discussion
Solved
Dax is not working in Measure
Hello,
I have written a following formula for Calculated column and measure. Formula is working for calculated column but for measure it is not working.
Column 2 = CALCULATE(SUM('Re-bar-Pile Cap -TD'[Total Weight]),'Data Sheet Sub-Structure'[Fnd. Case]=RELATED('Applicable Foundations'[App Fnd]))
Measure 2 = CALCULATE(SUM('Re-bar-Pile Cap -TD'[Total Weight]),'Data Sheet Sub-Structure'[Fnd. Case]=RELATED('Applicable Foundations'[App Fnd]))
Can you please guide, why this happened and what is the solution.
Thanks
You cannot use RELATED in measures. Use filter context instead.
1 Reply
- lbendlin
Super User
You cannot use RELATED in measures. Use filter context instead.