Forum Discussion

Alopez11's avatar
Alopez11
Regular Visitor
5 years ago
Solved

Count Data, help with Dax

Hello, I need a hand with a Dax formula I got the following data set: Date          Time    T°    1-1-2011   0:30     3 1-1-2011   01:00   3,5 1-1-2011   01:30   3 1-1-2011   02.00   3 Etc...
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Alopez11 Try:

    Count = 
  COUNTROWS(
    FILTER(
      SUMMARIZE('Table',[Date],"__Min",MIN('Table'[T])),
      [__Min] >= 10 && [__Min] <= 20
    )
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Alopez11 Try:

Count = 
  COUNTROWS(
    FILTER(
      SUMMARIZE('Table',[Date],"__Min",MIN('Table'[T])),
      [__Min] >= 10 && [__Min] <= 20
    )
  )
Alopez11's avatar
Alopez11
Regular Visitor
5 years ago

Hello Greg_Deckler 
thanks for your help, is now working
I have to make an upgrade to your formula as only use the Min value and not the Max so I made the following

Dias Efectivos de Polinizacion =
countrows(FILTER(SUMMARIZE('Base de Datos','Date'[Date],"__MIN",min('Base de Datos'[T°]),"__MAX",max('Base de Datos'[T°])),[__MIN]>=10&&[__MAX]<=20))
Thanks!