Forum Discussion

Credential's avatar
Credential
Frequent Visitor
4 years ago

Performance semantic model measure vs custom measure

Hello together, I have a question about custom measures. I have created a measure in my semantic model which is quite slow. The measure takes about 15 seconds. If I define the same measure as a cus...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

That is indeed quite strange. I can't think of a good reason for a Report Level Measure to be faster than the same measure defined in the tabular model. Can you verify that it's not related to caching?

Credential's avatar
Credential
Frequent Visitor
4 years ago

I know and don't understand either.
We always execute the queries in DAX Studio with a cleared cache. I have no idea why the one time 17 queries and the other time 35 queries are executed on SE.