Power BI Running total for Divide function

[UDMH]

For Example,

Here I have a sales data against Product.

[MFelix]

Hi @UDMH ,

Create the following measures:

Sales = SUM(Sales[Values])

Percentage = DIVIDE(
			[Sales],
			CALCULATE(
				[Sales],
				REMOVEFILTERS(Sales[Prod])
			)
		)


Running Sum Percentage = CALCULATE(
			[Percentage],
			WINDOW(
				1,
				ABS,
				0,
				REL,
				SUMMARIZE(
					ALLSELECTED(Sales),
					Sales[Prod],
					"SalesTotal", [Sales]
				),
				ORDERBY(
					[SalesTotal],
					DESC
				)
			)
		)

[UDMH]

But, how this works based on year wise data

[MFelix]

Hi @UDMH 

What do you mean by a Year wise data?

In the example you gave there was only Product and Sales Amount. Can you please elaborate on the final result you need to achieve,

[UDMH]

Hi @MFelix ,

Thank you for your support.

I have few more steps to bring the output.

After getting running sum percentage, I need to categorize this one under A, B, C.
The output should be,

Since this is a measure, the listing of category is not working.
And, also the sales data is huge, since we're using summarize in the measure, it keeps on loading and finally show error as visual exceeding the limits.
Whether there is any alternate way to the solution?

[MFelix · Accepted solution]

Hi @UDMH ,

For the number of rows add a table with the folowing data:

Add the following measures:

Percent Rank = RANKX ( ALLSELECTED(  Sales ), [Sales], , DESC )

Percent Running Total = 
VAR __rank = [_Percent Rank]
RETURN
SUMX (  FILTER ( ALLSELECTED ( Sales ), [Percent Rank] <= __rank ), [Sales] ) 

Nº Items = 
VAR __countBelowPercent =  [Sales]  * SELECTEDVALUE('Category'[Min])--store threshold percentabge
VAR __countBelowPercent1 =  [Sales]  * SELECTEDVALUE('Category'[MAX])
RETURN 
COUNTX ( 
    Sales, 
    IF ( [_Percent Running Total] >= __countBelowPercent  && [_Percent Running Total] <= __countBelowPercent1  , 1 ) 
)