Forum Discussion

Maryam_Pour's avatar
Maryam_Pour
Frequent Visitor
4 years ago
Solved

Distinct Count based on another column values

Hi All, Hope you can help me with the DAX. I have a big table of all Mails for different projects. Sometimes, the same mail number is duplicated both in Inbox and sent box, as some people add the...
  • amitchandak's avatar
    4 years ago

    Maryam_Pour , if only one mail no per project

    countrows(summarize(Table, Table[project], Table[mail no]))