Forum Discussion
Count(distinct) not working
Hi I'm having trouble getting Count(distinct) to work. I have a table that i would like to get a count of the distinct project numbers and the total of lab hours associate with each distinct project ...
amitchandak
Super User
Super Useravujica , You should be able to get is using
distinctcount(Table[Lab Project Number]), But as the projects are repeating, grand total will not sum up in case you are checking across some other axis/group
And may observe differences at line level avg and overall average.
Can you share sample output in a table format, if the issue not resolved by the last update from Greg?
Hi Thank you for your help but your solution did not help. If you have time please see the post i made in this thread regarding my observations.
Thank you again for your help.