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]
Thanks and Regards,
Go to Solution.
Distinct Count =CALCULATE(DISTINCTCOUNT([CUST_CODE] & [SALESREP_CODE]),FILTER(Table1,Table1[VISIT_IND] <> "A" && Table1[CUST_CODE] <> "99999"))
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.