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 ,

 

So based on your data sample, the output should be:

If so, please modify the Flag measure:

Flag = 
var _min=CALCULATE(MIN('Hoja1'[T°]),FILTER(ALL(Hoja1),[fecha]=MAX('Hoja1'[fecha])-1))
var _max=CALCULATE(MAX('Hoja1'[T°]),FILTER(ALL(Hoja1),[fecha]=MAX('Hoja1'[fecha])-1))
return 
CALCULATE(DISTINCTCOUNT(Hoja1[fecha]),FILTER('Hoja1',10<=_min && 20<=_max))

 

 

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.