cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ADSL
Post Partisan
Post Partisan

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors