Forum Discussion

Ignacio_Vidal's avatar
Ignacio_Vidal
Frequent Visitor
9 years ago

Displaying measures via SWITCH function affects performance

  Hi everybody. I'm developing a project with more than 200 measures and 100K rows (and is intended to support 14M rows in the future), so any performance improvement is a big thing. ...
Need Help
DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

200 measures are alot! Probably it's possible to reduce the number of measures using a more appropriate model design. That should lead to a better performance as well.

 

 

  • Ignacio_Vidal's avatar
    Ignacio_Vidal
    Frequent Visitor
    9 years ago

    Hi DoubleJ, thanks for the reply!

    Unfortunately its not possible. The client requests more than 200 different KPIs in the same dashboard, eachone with different dates and filter conditions, so my only option is to do whatever its possible to reduce load times.

    Thanks for your answer, anyway :)