DAX counting rows driving me mad

[dmarc]

Hi,

I'm trying to learn DAX and at the moment its driving me mad

I have two tables moved into the data model

d_people (list of people details including their location code)
d_locations (unique list of building names to location codes)

in d_people there is a field loc_code

In d_locations there is a field loc_code and building_name

I've linked the two loc_codes in the mode.

In the d_locations table i'm trying to add a calculated formula that simply counts the number of people in each building,

e.g

loc code,building name, sum of people in that building

I thought

=COUNTROWS(d_people[Loc_code])

would work, but it doesnt

help please

 

[Kazlik]

You should be able to make a measure like the one bellow where d_people is your column name for people. Then make a pivot table and use this measure in the values.

CountPeople:=COUNTA(d_people[d_people])

 

[scottsen]

Give this a glance and see if it helps: Calculated Fields vs Calculated Columns | Tiny Lizard

COUNTROWS shoudl work fine.. though it takes a table (d_people) not a column (d_people[loc_code]). The measure will be dynamically evaluated at runtime to always be correct for the context. So, if you have a filter on a certain location (say you drop location on rows of a pivot table), then the COUNTROWS would only return those rows in that filter context (eg, at that location).