What does this total distinct count mean?

[Anonymous]

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.

The measure is just the distinct count of the agents' id in each table.

Thanks for the attention.

[Greg_Deckler]

@Anonymous 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, First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This 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/63376

Also, 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/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[Anonymous]

Thank you Greg,

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]

@Anonymous 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.