Count instances in specific intervals when parameter higher than a value

[Anonymous]

Hi all,

Hopefully this is quite straightforward, but I can't seem to be able to find the solution to it.

I have a parameter that changes based on different time bucket columns (1hr column, 15min column etc.)

What I would like to do is create a measure that will calculate the number of instances where the sum of the parameter on a 15min interval is above 25.

My data look like this on a pivot

	10:00 - 10:15	10:15 -10:30	10:30 - 10:45	10:45 - 11:00	...	...	...
Employer 1	15	19	25	15
Employer 2	22	55	40	22
Employer 3	30	40	26	30
Employer 4	45	20	40	45
Measure Required COUNT (Above 25)	2	3	4	2

What I would like to have as a final product is the below.

	10:00 - 10:15	10:15 -10:30	10:30 - 10:45	10:45 - 11:00	...	...	...
Measure Required COUNT (Above 25)	2	3	4	2

Any idea?

Thanks in advance

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

countx(filter(values(Table[Employee]), [Count measure] >1 ), [Employee])

For below visual , you can use show on row in Matrix

[Anonymous]

Thanks a lot @amitchandak ! That worked exactly the way I needed !!