Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RA_gov
Frequent Visitor

From a big list with duplicates, isolating records with certain criteria and counting

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_NAMECUSTODIAN_NAME
UNION BANKBUSINESS A
COMMUNITY BANKBUSINESS BB
COLORADO BANKCUSTODIAN
COLORADO BANKBUSINESS A
STANDARD BANKBUSINESS CCC
STANDARD BANKBUSINESS BB
DOVETAIL S&LBUSINESS A
MIDWAY BANKBUSINESS BB
MIDWAY BANKBUSINESS A
MIDWAY BANKBUSINESS CCC
MIDWAY BANKCUSTODIAN
UNION BANKCUSTODIAN
HAWAII BANKBUSINESS CCC
FIRST BANKBUSINESS CCC

 

 

 

11 REPLIES 11

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors