Get a count of filtered items meeting a certain condition

[Kirt1965]

Hello All,

Still new to Power BI, so apologies if what I’m asking is super easy. 

We are comparing current period hours worked to previous period hours worked per employee.  Each employee has a manager, director, and VP.  I have measures set up that work.  They are below.  I have a filter on the page for the previous calendar month we call the current period (not in code, I don’t know if that matters) to show only those where the percent change is 10% or more.

What I want is a count of instances meeting that condition (> 10%).  So for the limited example data below, where VP=VP1 the total count would be 2.  Count for Director1 = 2.  Count for Manager1 and 3 = 1 each, but count for Manager2 = 0.  This is for a chart that shows the counts at each level; VP, Director, Manager, etc. and Drillable.

I’m sure the way my instinct tells me to go is wrong – which is to flag a condition met as 1 and not met as 0 then sum the flag values. 

Any help on how I should REALLY do this would be greatly appreciated.

Thank you,
Kirt
----------------

Current Period OT Hours  = SUM(TIMECHARGE[Hours])

Previous Period OT Hours = CALCULATE([Current Period OT Hours], DATEADD(DateTable[Date],-1,MONTH))

Percent Change           = DIVIDE([OT Hours Change],[Previous Period OT Hours],BLANK())

VP	DIRECTOR	MANAGER	EMPLOYEE	CURRENT PERIOD HOURS	PREVIOUS PERIOD HOURS	PERCENT CHANGE	INCLUDE IN COUNT
VP1	Director1	Manager1	Employee1	50	40	25%	1
VP1	Director1	Manager1	Employee2	30	40	-25%	0
VP1	Director1	Manager2	Employee3	42	40	5%	0
VP1	Director1	Manager3	Employee4	44	40	10%	1
VP1	Director2	Manager4	Employee5	.......
.......

[parry2k · Accepted solution]

@Kirt1965 try this measure for count

Count over 10 Percent = 
COUNTX ( VALUES ( Table[Employee] ), IF ( [% Change Measure] >= .10, 1 ) )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Kirt1965]

Thank you for the help.  I had to play with what to put in for Table[Employee], but it looks like it is working now.  I appreciate it.

Kirt