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?
Go to Solution.
In this scenario, you already build the relationships between tables, then you just need to create measure like below:
Number Of ID =
COUNTA ( Agreement[AgreementID] ),
ALLEXCEPT ( District, District[District] )
Thank you @v-sihou-msft~
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.