Count vs Distinct Count for a dimension

[harpreetchatha]

I would like to get count and distinct count as well on a dimension column. How we can get that?

Suppost I have a studentid(numeric) studentname(Charater) column and name of student is repeating. How we can show output as

students name | Count of Student Name | Distinct Count of Studnt Name

Thanks,

Harpreet

[mfoeken · Accepted solution]

Hi Harpreet,

If you add a counter with value '1' as a column in your model and you select the student name, it will summarize all the counter values, 1 for each row. The distinct count will always be 1 if you add the student name column to the table.

Kind regards,

Martijn van Foeken | Interdobs