N Customers bring 50, 30, 20% Revenue

[Anonymous]

Hi Everyone,

So I have a following Data Set:

Revenue	CustomerKey
10	1
20	2
30	3
25	4
45	4
60	5
100	3

What I am struggling with is getting how many customers bring 50, 30 and 20% of Revenue respectively.

I am trying to get: 

% Revenue	Customers
50%	X
30%	Y
20%	Z

You help would be much appreciated.

[v-caliao-msft · Accepted solution]

@Anonymous,

Please refer to the steps below to see the details.

1. Create a table using the DAX below.
   Table = SUMMARIZE(Table3,Table3[CustomerKey],"CustomTotal",CALCULATE(SUM(Table3[Revenue]),ALLEXCEPT(Table3,Table3[CustomerKey])))
   
2. Create a table manually by Enter Data
   
3. Create a calculate column in new table.
   Column = CALCULATE(COUNT('Table'[CustomerKey]),FILTER('Table','Table'[CustomTotal]>SUM('Table'[CustomTotal])*Table4[%Revenue]))
   

Regards,

Charlie Liao