Forum Discussion
Power BI Running total for Divide function
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 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,
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 ) )