Forum Discussion
Helper IIPerformance Boost repetitive Measures
Hi showy ,
When working with a large-scale Power BI data model including a fact table with ~20 million records and ~1 million unique items managing dynamic pricing levels (Level10 to Level90) using separate measures can significantly degrade performance and maintainability. To improve performance and simplify your model, it’s essential to consolidate logic, minimize measure duplication, and reduce computational overhead during visuals rendering.
1. Normalize Pricing Levels in Power Query
2. Create a Disconnected Slicer Table for Price Levels
3. Write a Single Dynamic Measure
Hope this helps.
Warm regards,
Chaithra E.
Super UserLooking into this, shall come back shortly
Best
Super UserHow about this approach? A single measure, and it seems pretty fast but you can double check yourself
I shall try load pbix this into your googledrive
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
- FBergamaschi
I cannot laod there, my version is here, please let me know
https://drive.google.com/drive/folders/1Ec6P0HxEhgDbmjofmAhZiU3uPlAq8FGj?usp=sharing
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
showyHi FBergamaschi
thanks for your help.I tested your method in the actual report. I have also tried a similar method. Unfortunately, it is very slow and the table takes about 30 seconds to load.
I also considered using calculation groups, but I cannot find a suitable solution with that either.
- FBergamaschi
Can I have the full pbix to try optimizing performance?