Counting in Powerpivot

[one3nine0]

So I have two tables linked in Powerpivot by type

Table 1 has columns for date, person, and type

Table 2 has columns for type and cost

I want to have a count for each type in table 1 to show up in a new column on table 2

After searching, many people have had success with =CALCULATE(COUNT(table 1 date), filter(table 1, table 1 type=table 2 type))
But for me all this returns is the total number of rows in table 1 for every type, not the actual count of them.

I know i can use a pivot table to count, but I will not be able to use those values in further calculations which is what I am going for.

Also, completely new to Powerpivot... just upgraded

 

[Kazlik]

You could make a calc column like this or better make a measure COUNT(table1[type]) and let the pivot table do the rest

=CALCULATE(COUNT(table1[type]),FILTER(table1,table1[type]= table2[type]))

 

[scottsen]

Likely, all you really want is:
Person Count := COUNTROWS(PersonTable)

Assuming you have a relationship setup between your two tables... the count will be correct for any row within the Type table.