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

I've made the following chart

With the Max and Min temperature of each day and 2 min and max lines at 10°C and 20°C

Now, what I need is to count all the days that the min temperature is over or equal to 10°C and lower or equal to 20°C to display in a labbel

Thanks you very much for the help

 




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

2 Replies

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