Forum Discussion

BIanon's avatar
BIanon
Helper V
2 years ago

Measure performance issue

Hello community, Here is some sample data:   id tripid Value Value2 1 1 2,1 5 2 1 2,1 7 3 1 2,1 3 1 2 3,7 2 2 2 3,7 6 3 2 3,7 8 1 3 1,1 4 2 3 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BIanon ,

Based on the information you've provided, the performance bottleneck seems to be related to the way the metrics are calculated, try changing sumx to something like calculate(sum(), filter()) to see if that improves the speed. Here's a related document that will hopefully help you: DAX Performance issue: why is my SUMX() so slow? - Stack Overflow.

In addition, performance is also related to filters, filters, and data models, which can be found in the documentation:Optimization guide for Power BI - Power BI | Microsoft Learn.

 

Also, although you mentioned that adding an aggregate table seems a bit much, for measurements that aggregate large amounts of data, adding an aggregate table can dramatically improve performance, and it's not a bad way to go .

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

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