Forum Discussion
Solved
Power BI Running total for Divide function
For Example, Here I have a sales data against Product.
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 ) )
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?
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 )
)