Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |