Forum Discussion

Alopez11's avatar
Alopez11
Regular Visitor
4 years ago

Count Data, Help Again

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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Alopez11 ,

 

Please try the following formula to create a measure:

Flag = CALCULATE(DISTINCTCOUNT(Hoja1[fecha]),FILTER('Hoja1',10<=MIN('Hoja1'[T°]) && 20<=MAX('Hoja1'[T°])))

And apply it to filter pane to only show the date whose min>=10 and max>=20:

 

If you want to calculate the count of days, please use:

Count days = SUMX(VALUES(Hoja1[fecha]),[Flag])

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.