Distinct Count of Two Columns --- Customer Code & Call Date

[ADSL]

Hi BI Community Team,

As screenshot below, we have customer code & call date column and want to merge 02 these columns together and distinct count.

May I need your help of metric calculation, solution?

Best Regards,

[amitchandak · Accepted solution]

@ADSL ,Create a measure like

Countrows(Summarize(Table, Table[customer code],Table[call date]))

[ADSL]

Hi @amitchandak ,

Thank you for your helpful feedback.

Best Regards,