Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
65 | |
60 | |
56 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |