Frequencies/counts of a variable by another variable using DAX

[Paul-NYS]

Hi
I am new to Powerpivot and have a variable in Powerpivot that I want to run a frequency/count on, however the count would be by another variable. For example, the number of times a disposition happens within a given county. This is very easy in SAS and I am wondering if it is possible using DAX in Powerpivot?

The formula I started with was the following:

=countx(S5[phear9],S5[cnty_name])

However, that did not work. Has anyone done this before?

Paul

 

[powerpivotpro]

The answer involves a pivot table I think. As a starting point I'd put your County column on rows of the pivot and then write a measure that is SUM(S5[phear9]) or similar. I don't know what is stored in the [phear9] column so it's hard to say.

(Not to sound too commercial but I think you would benefit quite a bit from a copy of my book.)