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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.