Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Non intuitive total


Im having a logic doubt problem that I hope you can help with.

I have a column with Orders, Distinct Customer, Orders per Distict Customer. 


orders  = SUMX(Orders,Orders[Count])

distict Customer = DISTINCTCOUNT(Orders[Customer_code])

orders per distinct cust = [orders]/[distict Customer]


23-03-06 15_21_16.png


All the numbers in that table are correct. However, the 2022 number is not intuitive. It should be around 56.


How would you enforce that?

Super User
Super User

Hi @fosterXO 
You may try something like:

distict Customer =
    SUMMARIZE ( 'Table', [Year], [Month] ),
    CALCULATE ( DISTINCTCOUNT ( Orders[Customer_code] ) )
Community Champion
Community Champion

hi @fosterXO 

it is not intuitive , because distinctcount is semi-additive, or because one Customer_code could present at multiple months, but it is counted once only in Year 2022.  Make sense?

Yes, the question would be how to show something that is more intuitive for users. Maybe an average?

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors