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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 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.

Sept NL Carousel

Fabric Community Update - September 2024

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