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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ADSL
Post Prodigy
Post Prodigy

Merging columns and Distinct count with condition

Hi BI Community Team,

 

I have a table below and want to merging the column of [CUST_CODE] & [SALESREP_CODE] together and then using "distinct count" to count. For "distinct count", some conditions are not included: 

 

1. Value "A" of [VISIT_IND]

 

2. Value "99999" of [CUST_CODE]

 

2023-06-08_21-03-28.png

 

Any suggestion/advise?

 

Thanks and Regards,

1 ACCEPTED SOLUTION
aaitelkadi
Frequent Visitor

Distinct Count =
CALCULATE(
DISTINCTCOUNT([CUST_CODE] & [SALESREP_CODE]),
FILTER(
Table1,
Table1[VISIT_IND] <> "A" && Table1[CUST_CODE] <> "99999"
)
)

View solution in original post

1 REPLY 1
aaitelkadi
Frequent Visitor

Distinct Count =
CALCULATE(
DISTINCTCOUNT([CUST_CODE] & [SALESREP_CODE]),
FILTER(
Table1,
Table1[VISIT_IND] <> "A" && Table1[CUST_CODE] <> "99999"
)
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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