Potential Performance Issues

[aishak12]

I will be creating almost 1770 Dax formula's containing IF statements and curious if this is possible or would cause any performance issues in the future. 

I am attempting to replicate financial statement to powerBI and all the data will be coming from SQL in 3 views that contain 2000 rows each and will all be appended together. 

[AlexisOlson]

I'd be way more worried about maintenance issues than performance with that many measures.

With less than 10,000 rows of data, I wouldn't expect much in the way of performance problems unless your formulas are particularly pathological.

[amitchandak]

@aishak12 , Measures are usually a definition, so they will not add to size. But 1700 is too many. Performance may slow down by measure calculation. Not by the number of measures

Consider calculation groups, if those can help

https://www.youtube.com/watch?v=vlnx7QUVYME

https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/