Forum Discussion
Performance Problem - Converting Measure to Column
Scenario: Evaluating personal quality, by different metrics. For example if John reported 3 cases and he is from accounting. If accountants report 3 cases, they got 100%, therefore John . Felipe rep...
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi felipeveiga,
The calculated column and calculated table could be the way to store temporary data. But sometimes they wouldn't help. The structure of the data mode is also important to speed up the mode. Can you share a dummy sample? Reference: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance.
Best Regards,
Dale
Is there any way to instead of creating a calculated table, to store the calculated data?
Is there any way to export with dummy data?
- v-jiascu-msft
Hi felipeveiga,
Usually, we can use the table functions like SUMMARIZE to store the processing data without creating a calculated table. Maybe you can keep the structure of your data model and some featured data.
Best Regards,
Dale