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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Ignacio_Vidal,

 

Sorry for slow response, but I still not found the documents which mentioned the performance cost of switch function.

 

In my opinion, I think the performance issue more related to your filters which written in the measure. If you use this measure calculate on large amount of records, it may take more resource than single measure.

 

>>I know CALCULATE is faster, but the date restrictions force me to use the filter function, because they're variable restrictions.

Calculate also support multiple filters on it.

 

Regards,

Xiaoxin Sheng

Ignacio_Vidal's avatar
Ignacio_Vidal
Frequent Visitor
9 years ago

Hi Anonymous, thanks a lot for your effort.

I will try to change some measures to calculate then. Good news are that I found some performance improvements that made my program work again, so the SWITCH problem, yet unknown, is not so important now. If I found any reason that justifies this behaviour, I will post it in here.

Kudos to you!