Forum Discussion
Distinct Count with condition
Hi there I have a replicated and summary table from the real dataset. Floor User Name Session Time Hourly Level 1 Alice 8:38:00 8am Level 1 Alice 9:06:00 9am Level 4 Els...
Anonymous , You can use dictinctcount(Table[User Name]) , Not clear on what issue your facing.
Can you share expected output ?
Thanks for your suggestion.
Although, if a distinct count is used, the sum of the total for all floors would be 30. I would like to distinct count by the first visit to a floor within an hourly time frame.