Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
107 | |
97 | |
38 | |
32 |
User | Count |
---|---|
153 | |
122 | |
77 | |
74 | |
44 |