[Help] Count in DAX!

[harakuruku]

I have four tables. Table Agreement, Beaches, Connection and District.

Table Connection has a column AgreementID and BeachID.

Here is the relationship between the table:

Table Agreement &Table Connection through Agreement ID

Table Beaches & Table Connection through Beach ID

Table District & Table Beaches through District ID

Now, what I want to count is the number of Agreement ID per District. Sample data:

Result should be like this:

Should I create a measure column or merge queries?

Thank you!!!

[v-sihou-msft · Accepted solution]

@harakuruku

In this scenario, you already build the relationships between tables, then you just need to create measure like below: 

Number Of ID =
CALCULATE (
    COUNTA ( Agreement[AgreementID] ),
    ALLEXCEPT ( District, District[District] )
)

Regards,

[harakuruku]

Thank you @v-sihou-msft~