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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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