What does this total distinct count mean?

Question

Hi everyone,I was asked to show the amount of agents in a call center for each result in the rows.My question is, what do these totals mean? They are much higher than the max value shown in the rows. The columns below are part of two different tables.&nbsp;The measure is just the distinct count of the agents' id in each table.&nbsp;Thanks for the attention.&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

Anonymous&nbsp;The "totals" are the number of the disctinct count over the entire set of rows in the current context. If you want it to be something different,&nbsp;First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742eThis looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Also: https://youtu.be/uXRriTN0cfYAnd: https://youtu.be/n4TYhF2ARe8

anonymous · Answer

Thank you Greg,&nbsp;But how can I make it show something that makes sense, like the max distinct count or something like that?If I show those results, the users will say the total count doesn't make sense...

greg_deckler · Answer

Anonymous&nbsp;That's what the article shows how to do. In particular, it uses SUMX for the total to add up all of the individual rows. If you want something else, just use MAXX, MINX, AVERAGEX, etc. Or, just turn the total off.

Forum Discussion

What does this total distinct count mean?

3 Replies

Related content

count distinct

Distinct Count

Total Count in Column

Distinct count

List distinct from a matrix row totals and count employees