Need a Dax formula to count how many groups are meting a metric in PowerPivot

[rizz0]

I have a calculation in powerpivot "Scheduled Utilization". This is based off a couple other calculations. If I bring this into a pivot table it will break down "Scheduled Utilization" by Group and Sub Group.

I created another calculation off of this one. My boss wanted a pivot table of multiple calculations with a simply Y or N if they are or are not meeting the goals for each metric. So I was able to do this using this calculation:
Sched Util:=IF([Scheduled Utilization]>=.86,"Y","N")
When I bring this into a pivot table with 5 groups and probably 30 subgroups it works just fine. What I need to some how do now is count how many of these groups and subgroups are meeting their goals. I could easily do this with a formula in the excel worksheet the pivot table is on but my boss wants it all done in PowerPivot. Reason for this is the subgroups will change over time when new ones are added and others are removed. Any ideas how I could accomplish this in PowerPivot?

Once I finish this report it will be uploaded to Sharepoint and will run once each week.

I am only a few months into using powerpivot so I am a little green. Hopefully I have explained what I am trying to accomplish.


Excel 2013 (64bit)
Windows 7

Thanks!

 

[Gordonik]

If you have used:
Sched Util:=IF([Scheduled Utilization]>=.86,"Y","N")
to create a new "Calculated Column" [Sched Util]
you can easly count "Y","N" with a measures:
Meet a Goal:=COUNTA('Your table'[Sched Util];[Sched Util]="Y")
Missed a Goal:=COUNTA('Your table'[Sched Util];[Sched Util]="N")

or just
Goal=COUNTA('Your table'[Sched Util])
then you can use [Sched Util] in a pivot filter or rows to show both Y/N occurences

 

[rizz0]

I am doing all the calculations in the lower section of powerpivot.(not sure what its called) Looks like COUNTA is for the calculated columns.

 

[scottsen]

Try COUNTX.

 

[Gordonik]

"lower section"" means you have probably done a measure.
Just copy
Sched Util:=IF([Scheduled Utilization]>=.86,"Y","N")
to a newly created calculated column. You should get a column filled up with Y or N
Then use the above measures in a lower section.

Read some about "measures" and "calculated columns" in PowerPivot it will give you a more light how is the PP working

 

[rizz0]

Thanks for the responses. I will try these things later today.