Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 themselves as receivers when sending mails.
We use a system that generates the same mail number based on the type of mail, no matter which projects.
Therefore I have several duplicated mail numbers from different projects, which I only need to count one time.
How can I get the total count/distinct count of all mail numbers accros projects?
Solved! Go to Solution.
@Maryam_Pour , if only one mail no per project
countrows(summarize(Table, Table[project], Table[mail no]))
@Maryam_Pour , if only one mail no per project
countrows(summarize(Table, Table[project], Table[mail no]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |