Forum Discussion

android1's avatar
android1
Post Patron
10 years ago
Solved

Counting text values in 2 different Calculated Columns

Hi,   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[...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    android1 This should work...

     

    In Full & On Time =
COUNTROWS (
    FILTER ( 'OTIF', 'OTIF'[Punctuality] = "On Time" && 'OTIF'[InFull] = "In Full" )
)
Sean's avatar
Sean
Community Champion
10 years ago

android1 This should work...

 

In Full & On Time =
COUNTROWS (
    FILTER ( 'OTIF', 'OTIF'[Punctuality] = "On Time" && 'OTIF'[InFull] = "In Full" )
)
android1's avatar
android1
Post Patron
10 years ago

Hi Sean,

 

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.

  • android1's avatar
    android1
    Post Patron
    10 years ago

    Thanks to smoupre too for your input.