Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.