And the .pbix file is also attached at the end. Hope it works for you.
Certainly perfecting transformation should still have the consideration of performance issues. Based on the operations above, more measures, calculated columns, visuals and report pages are included in the report. There’s one problem with this – will this affect the performance?
There will only be a slight impact, which is caused by the repeated calculated columns. Since all pages except the homepage are hidden, when the report is viewed on the service, only the visuals and measures related to the page jumped to will affect performance. Therefore, there is not much difference in performance in this regard.
Hope this article helps everyone with similar questions here.