Field Parameter Performance Issue

[lherbert501]

Hi,

I have a layout as in the image below, but I'm having real performance issues. I presume this is from the amount of field parameters, but I was just seeing if there was an alternative way to shape this? 

I'm finding union chunks of data in SQL and creating the parameter in my data is a lot quicker however, it's a lot more rows and alot more messy.

Below is an example of one of the measures, with the page column linking to a dimension to control the whole page for sales/profit.

Thanks

Liam

[lbendlin · Accepted solution]

"It depends".  It depends on the performance of your measure queries and on the cardinality of the participating columns. Use DAX Studio to explore the query plans and isolate the performance bottlenecks.

[lherbert501]

Okay thankyou @lbendlin