Forum Discussion

Bebs's avatar
Bebs
Helper II
2 years ago

Optimisation : removing fields

Hello, I've a big application with a lot of fields. I'd like to optimize it and I've some doubts that some fields are not necessary : For the final user, is it better to completely remove a field f...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks solutions from samratpbi 

Hi, Bebs 

Depending on your needs, if you hide these fields in your model, they will not be visible to the end user who reads the report, but you can still make calculations based on these hidden fields, like auxiliary calculations for other measures, etc. If you choose to delete these fields, then they will be permanently deleted and can no longer be used for calculations, which helps reduce the model size, mentioning overall performance, which will be an optimization for large datasets. Both methods have their own advantages and disadvantages, and you should make a suitable choice based on your actual situation.

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.