Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago
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 are not included: 

 

1. Value "A" of [VISIT_IND]

 

2. Value "99999" of [CUST_CODE]

 

 

Any suggestion/advise?

 

Thanks and Regards,

Need Help
  • aaitelkadi's avatar
    aaitelkadi
    3 years ago

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

1 Reply

  • aaitelkadi's avatar
    aaitelkadi
    Frequent Visitor
    3 years ago

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