Forum Discussion
Solved
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...
Distinct Count =
CALCULATE(
DISTINCTCOUNT([CUST_CODE] & [SALESREP_CODE]),
FILTER(
Table1,
Table1[VISIT_IND] <> "A" && Table1[CUST_CODE] <> "99999"
)
)
Distinct Count =
CALCULATE(
DISTINCTCOUNT([CUST_CODE] & [SALESREP_CODE]),
FILTER(
Table1,
Table1[VISIT_IND] <> "A" && Table1[CUST_CODE] <> "99999"
)
)