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?
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.
=IF([status] = "compliant", 1 )
You can then click on that new column and the pivot table will perform the default SUM aggregate
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?