Top 80% Engagement

 What I needed was the number of the clients, in your example the measure would be "3".

So I get the approach with this:

I have a CalculateTable that summarizes the clients' name by month (that is why I use CALCULATETABEL and ALLEXCEPT with the calendar table in my measures) and also ranked them by volume. 

So in this table I created a cummulative measure and total volume (no matter what filter apllies, only filters from the calendar table).

Cumulative Volume_RMX = CALCULATE(SUM(Rank_clientes_RMX[Volumen]),
                            FILTER(
                                CALCULATETABLE(Rank_clientes_RMX,ALLEXCEPT(Rank_clientes_RMX, Calendario, Rank_clientes_RMX[Calendar YearMonth])),
                                Rank_clientes_RMX[Rank]<=MAX(Rank_clientes_RMX[Rank])
                                )
                            )

volume_all_month_RMX = CALCULATE(SUM(Rank_clientes_RMX[Volumen]),ALLEXCEPT(Rank_clientes_RMX,Calendario,Rank_clientes_RMX[Calendar YearMonth]))

Then I created the final measure

Clientes 80 % vol. = CALCULATE(COUNTROWS(Rank_clientes_RMX),
                                    ALLEXCEPT(Rank_clientes_RMX, Calendario, Rank_clientes_RMX[Calendar YearMonth]),
                                    FILTER(
                                        CALCULATETABLE(Rank_clientes_RMX, ALLEXCEPT(Rank_clientes_RMX, Calendario, Rank_clientes_RMX[Calendar YearMonth])),
                                        [Cumulative Volume_RMX]<[volume_all_month_RMX]*0.8
                                    )
                                )+1

The final measure, get the number of clients that makes less than 80 % of the total volume + 1. 

I hope it helps someone.

Regards,

Giovany

Hello Ashish_Mathur,

the solution you provided fits to my problem. But I need to include a time filter as well.

I reconstructed your solution. The Ranking works. But the cumulative total doesn´t work.

Kumulativer Umsatz = SUMX(TOPN([Pos. Debitoren];CALCULATETABLE(VALUES(Kalender[Datum]);ALL(Kalender[Datum]));[Absoluter Umsatz]);[Absoluter Umsatz])

I add my measures to your code.

Pos. Debitoren = Rank 

Kalender[Datum] = Date 

[Absoluter Umsatz) = Total

Do you have an idea to solve my problem ?

Thanks for your help!

Christian

This is a great idea! Thank you!