Cumalitive total in % for each region

[Anonymous]

Hi All,

Can you please help me how i can cumalitive total as % for each region as 100 week over week. 

For eg. I have week 1 to 10 and 3 region as X, Y, Z 
Suppose X has done total sales as 10

Suppose Y has done total sales as 20

Suppose X has done total sales as 30.

So i am looking line graph as Wk1,2,3,4,5,6,7,8,9,10 in X axis and show % for each region as 100%. Below is sample graph i am trying to build.please suggest. Thanks in advance.

[parry2k · Accepted solution]

@Anonymous this will do it, add this as a measure and change table and column name as per your model

Would appreciate Kudos 🙂 if my solution helped. Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

Cumulative % =
DIVIDE (
    CALCULATE (
        SUM ( Week[Sales] ),
        FILTER ( ALL ( Week[Week] ), Week[Week] <= MAX ( Week[Week] ) )
    ),
    CALCULATE ( SUM ( Week[Sales] ), ALL ( Week[Week] ) )
)

[Anonymous]

Thanks @parry2k  for the solution that solves my problem. Another help is how to get the top n account for each region based the sales.

I am able to get the output but in result the region & account name is coming as a one column.I am looking like below output.  Can you please suggest for this. Thanks in advance & appreciate your help. 

Summary based on the total N slaes for each region it should give output like below.