Forum Discussion

Frequent Visitor

4 years ago

Solved

Distinct count problem for total

Hi! I´m having a problem trying to use distinctcount. I have a database with customers by region, one customer can make a purchase in different regions and, in some cases you can have the same cu...

Greg_Deckler
4 years ago
AgustinBrocardo 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

Greg_Deckler

Community Champion

4 years ago

AgustinBrocardo 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

AgustinBrocardo

Frequent Visitor

4 years ago

Thank you very much, it worked perfecly and the explanation is easy to follow!

I´m still very limited in relation to DAX but these type of answers help me a lot to keep learning the logic behind the code.

Forum Discussion

Distinct count problem for total

Related content

count distinct

Distinct Count

Distinct count

DAX Calculation for Distinct Count

COUNT DISTINCT