Help with Calculate Function in PowerPivot

Question

I have a power pivot table to report of the number of machines that received the latest MS patch.

The Row lables are "compliant", "enforcement state unknown" and "failed to install updates"

Each of these rows shows a total with a grand total at the bottom summing them all.

How do I use the calulate function to create a new measure that will show the number of machines that are compliant?

Answer 1

One way of doing this is to create a new calculated column (on the PowerPivot window) and then a conditional if statement to count as "1" when the machine is compliant.

Something like:

=IF([status] = "compliant", 1 )

You can then click on that new column and the pivot table will perform the default SUM aggregate

---

Javier Guillen
http://javierguillen.wordpress.com/