Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!!!
Solved! 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 = CALCULATE ( COUNTA ( Agreement[AgreementID] ), ALLEXCEPT ( District, District[District] ) )
Regards,
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,
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |