Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
From TABLE1 containing all banks and their custodians, I need a DAX query(s) that isolates only BANK_NAME where CUSTODIAN_NAME = 'CUSTODIAN' ... and from that listing, shows me counts for all their other custodians.
Restults would look like:
COLORADO BANK 1
MIDWAY BANK 3
UNION BANK 0
Thanks for the help!
RA
TABLE1
BANK_NAME | CUSTODIAN_NAME |
UNION BANK | BUSINESS A |
COMMUNITY BANK | BUSINESS BB |
COLORADO BANK | CUSTODIAN |
COLORADO BANK | BUSINESS A |
STANDARD BANK | BUSINESS CCC |
STANDARD BANK | BUSINESS BB |
DOVETAIL S&L | BUSINESS A |
MIDWAY BANK | BUSINESS BB |
MIDWAY BANK | BUSINESS A |
MIDWAY BANK | BUSINESS CCC |
MIDWAY BANK | CUSTODIAN |
UNION BANK | CUSTODIAN |
HAWAII BANK | BUSINESS CCC |
FIRST BANK | BUSINESS CCC |
User | Count |
---|---|
53 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |