I have an unpivoted column I want to be summed. I have tried the following:
Amount at recent date = CALCULATE( SUM('Amount'[Value]); FILTER('Amount';'Amount'[ActualStart] = MAX('Amount'[ActualStart])))
However, this does not seem to work. Anyone have any idea why it does not?
I used the same piece of code in another unpivoted column, where the represented values are 1 and 0. However the problem occurs when the values exceeds this.
Solved! Go to Solution.
You created a calculated column, right? The syntax of your DAX formula is right. In your sample table, what's the data type of 'Amount'[ActualStart]? Could you please share your sample table for further analysis?