Forum Discussion

ADSL's avatar
ADSL
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

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

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,

  • ADSL ,Create a measure like

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

2 Replies

  • ADSL ,Create a measure like

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