Count Distinct

[Anonymous]

Hello,

I am looking to see the total values of one column based on the distinct features of another column.

I have a column with 6 different teams which totals to 1.5k. Each of the teams has a range of different addresses in another column so, for example:

Team 1 totals to 600 but has 6 different address' so I would like the total to show as 6 rather than 600 for that particular team

Please could you help with a count distinct formula

Thank you

[tm_burgers]

First Column is a dimension - [Team]

2nd column measure = Count(distinct [Address]) ?

[Anonymous]

Thank you. I was wanting to do this on a KPI chart so do you know what the best expression would be for this please? Thank you

[tm_burgers]

wouldn't :

Count(distinct [Address]) in the KPI give you the result you are looking for?

if you want a KPI measure for a specific team you could use;

Count( {<  [Team] = {'TeamName'} >} distinct [Address])