Forum Discussion
Dashboard Report loading slowing while using semantic model Measures.
I have a report that is using semantic model. and in the report i crated a measure that is calling another measure using switch condition which is taking time is this a good practice, please suggest ...
Hi devaj123
Whether that is a good practice, really depends. If you are using direct query to a semantic model then expect some delays. DQ after all is not as fast as import. That aside, it could be the measures themselves used in switch that have problems. You may be filtering a table when you're supposed to filter just a column or columns or you're using iterator functions on high cardinality virtual tables.