Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
MaBla2
New Member

Count number of customer exceeding certain size

I'd like to count the number of customers exceeding a certain size of billings (KPI). Example: How many customers exceed a grand total of 50'000$ in billings in a given period?

 

I was able to count the number of OrderID exceeding a certain value but not the number of customer.

 

My raw data looks like this:

YearMonthCustomerCustomerIDOrderIDBusiness UnitProductQtyBillings
20153A1000120001Xa14'000
20153B1000220002Xa520'000
20153C1000320003Yb120'000
20154B1000220004Yc190'000
20155C1000320005Zd13'000
20155A1000120006Za30120'000
20156D1000420007Xe1280'000
20156A1000120008Yf110'000
20157E1000520009Zg222'000
20157B1000220010Xh15'000
20158F1000620011Yh945'000
20159E1000520012Xd1030'000

 

Can anybody help me? 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Something like:

 

Total Billings = SUM(MyTable[Billings])

High Value Customers =CALCULATE( DISTINCTCOUNT(MyTable[CustomerID]), FILTER ( VALUES(MyTable[CustomerId]), [Total Billings] > 50000) ) )

 

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Something like:

 

Total Billings = SUM(MyTable[Billings])

High Value Customers =CALCULATE( DISTINCTCOUNT(MyTable[CustomerID]), FILTER ( VALUES(MyTable[CustomerId]), [Total Billings] > 50000) ) )

 

 

Hello, is there a way to do this 12month rolling?

Thanks in advance.

 

Cheers

That is just perfect, thank you scottsen!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.