I have 2 calculated Columns -> InFull = IF([ActualDuration]<[ScheduledDuration]*.85,"Not In Full","In Full") &
Punctuality = IF (OTIF[DutyTimeFrom]<OTIF[TimeFrom]-1/24*.25,"Early",IF (OTIF[DutyTimeFrom]>OTIF[TimeFrom]+1/24*.25,"Late","On Time"))
I need to add the total number of times that the text 'In Full' appears & "On Time". I only want to add them if both appear.
Solved! Go to Solution.
InFullOnTime = CALCULATE(COUNT([SomeColumn]),FILTER(OTIF,OTIF[InFull] = "In Full"),FILTER(OTIF,OTIF[Punctuality] = "On Time"))
Proud to be a Datanaut!
I was sure when I saw your && suggestion that it was something I had already tried.
But whatever, yours works perfectly. The Matrix option is very interesting.
Thanks a million for this.