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
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:
Year | Month | Customer | CustomerID | OrderID | Business Unit | Product | Qty | Billings |
2015 | 3 | A | 10001 | 20001 | X | a | 1 | 4'000 |
2015 | 3 | B | 10002 | 20002 | X | a | 5 | 20'000 |
2015 | 3 | C | 10003 | 20003 | Y | b | 1 | 20'000 |
2015 | 4 | B | 10002 | 20004 | Y | c | 1 | 90'000 |
2015 | 5 | C | 10003 | 20005 | Z | d | 1 | 3'000 |
2015 | 5 | A | 10001 | 20006 | Z | a | 30 | 120'000 |
2015 | 6 | D | 10004 | 20007 | X | e | 1 | 280'000 |
2015 | 6 | A | 10001 | 20008 | Y | f | 1 | 10'000 |
2015 | 7 | E | 10005 | 20009 | Z | g | 2 | 22'000 |
2015 | 7 | B | 10002 | 20010 | X | h | 1 | 5'000 |
2015 | 8 | F | 10006 | 20011 | Y | h | 9 | 45'000 |
2015 | 9 | E | 10005 | 20012 | X | d | 10 | 30'000 |
Can anybody help me?
Solved! Go to Solution.
Something like:
Total Billings = SUM(MyTable[Billings])
High Value Customers =CALCULATE( DISTINCTCOUNT(MyTable[CustomerID]), FILTER ( VALUES(MyTable[CustomerId]), [Total Billings] > 50000) ) )
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
91 | |
84 | |
76 | |
65 |
User | Count |
---|---|
145 | |
109 | |
109 | |
102 | |
96 |