Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a report, that shows the Top n Sub-Categories and Other by Sales Amount.
For the selection of the Top n i created a table with values from 1 to 10.
Select Top n = {1,2,3,4,5,6,7,8,9,10}
I created another table with the Sub-Categories + Other as follows:
Sub-Category and Other =
UNION(
The calculation for the Top n + Other:
This is the result for top 4 that i get and expected:
Now i want to get the Sales value by year for the top 4 and Other. But when i add the year it changes my filter context and i get the top 4 by year:
This is the result i am trying to achieve is the yearly Sales amount by the top 4 of the total Sales amount:
hi , did you reached to the solution. Actually i am having a same requirement. If yes, please do share the solution.
@akoschinek , refer if this approach can help
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
https://goodly.co.in/top-n-and-others-power-bi/
Thank you for your response.
I actually used this approach to get the Top N and Others.
What i can't get to work, to split this by year without getting the Top N by year, but the yearly amount of the Overall Top N and Others.
Thank you, i wasn't aware the WINDOW function had been added.
But from what i can see i can get the top N Sub-Categories by year, instead of having the overall top N and then taking these and het their value per year.