Forum Discussion
Better model to improve the performance calculated table/Dax measures
Hi Team, Now, I have an issue with Data model I have developed. Attached is the model i use for my power bi reports that contains 3 dashboards. Invoice quality is one of the dashboards. Below a...
Hi SergeiBaklan sir,
Apologies for the delay in response!
I have attached the sample data herewith https://1drv.ms/u/c/cfada767f73d87ed/ETj2wIZSKuJOuEoeDeuKN8IBKEfK5rBqmHSzDCCvajvYMA?e=EqkKG9
Can you please help me remodel this into a star schema?
There are lot of thoughts/ideas running in my mind to optimize this model:
- Creating star schema(Because current data model has no structure. It is what we call a spagetti model)
- Power BI’s calculation groups instead of multiple calculated columns. This can offload some logic to runtime and help with performance
- using dynamic DAX measures that respond to the current filter context. This approach enhances report interactivity, reduces memory overhead, and significantly improves model performance by calculating only what's needed, when it's needed.
- Also for transformations that don't need to respond to user interactions, consider performing them in Power Query. This can offload processing from DAX and improve overall performance
Please guide us!🙏
