Hi All
I've been going up the wall with trying to understand this concept in the last few days.
This is a calculated column and there are two tables, LearningPlan (1) and Activities (Many)
I understand how ALL works to remove filters in a visual but in a calculated column i'm lost.
I know that context transition introduces a filter context for the current row but don't we want to keep that context so we can find id's from the current row in the Activities table?
It seems like thats what is happening anyway except at first we remove the filters, only to put them back on.
What filters could be applied in at table level?
I've been going up the wall with trying to understand this concept in the last few days.
This is a calculated column and there are two tables, LearningPlan (1) and Activities (Many)
I understand how ALL works to remove filters in a visual but in a calculated column i'm lost.
I know that context transition introduces a filter context for the current row but don't we want to keep that context so we can find id's from the current row in the Activities table?
It seems like thats what is happening anyway except at first we remove the filters, only to put them back on.
What filters could be applied in at table level?
Code:
CALCULATE(
MAX(Activities[Submission date]) ,
FILTER ( ALL ( 'Activities'[LearnerID]) ,
'Activities'[LearnerID] = LearningPlan[LearnerID])
)