Forum Discussion

android1's avatar
android1
Icon for Post Patron rankPost 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" )
)
android1's avatar
android1
Icon for Post Patron rankPost Patron
10 years ago

Thanks for your reply. Can I use Count when dealing with strings? Getting the error attached.

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Use COUNTA

  • android1's avatar
    android1
    Icon for Post Patron rankPost 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
      Icon for Community Champion rankCommunity 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
        Icon for Community Champion rankCommunity Champion
        10 years ago

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

         

        Countrows = COUNTROWS('Table')