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" )
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Use COUNTA

android1's avatar
android1
Post Patron
10 years ago

Can you explain what column [Some Column] should refer to? I tried referencing both [In Full] & [Punctuality] 

with no joy.

  • 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" )
)
    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      android1 you could also just create a Matirx and use a simple Measure like in the picture

       

      Countrows = COUNTROWS('Table')

       

    • 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.