Merging columns and Distinct count with condition

[ADSL]

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]

Any suggestion/advise?

Thanks and Regards,

[aaitelkadi · Accepted solution]

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