Forum Discussion
Julia2023
Helper I
Helper ICumulative sum for ranking
Hello, Could someone help me create a Ranking measure that’s a cumulative sum of the Position measure, ensuring it adds up to 100%? Any tips or methods would be really appreciated. Position =
V...
Julia2023Helper I
Helper IJihwan_Kim, thank you so much for this detailed walkthrough. This solution (WINDOW) was exactly what I was looking for. However, in my case, if I don’t apply the TOP N filter with this measure, I get an error saying there isn’t enough memory. Do you know the reason for this and how I can resolve it?
Hi Julia2023 , hello Jihwan_Kim and rohit1991, thank you for your prompr reply!
Consider optimizing your solution at different architectural layers. Layers include:
- The data source(s)
- The data model
- Visualizations, including dashboards, Power BI reports, and Power BI paginated reports
- The environment, including capacities, data gateways, and the network
More information for your reference:
Optimization guide for Power BI - Power BI | Microsoft Learn
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.