Forum Discussion

Tanya0806's avatar
Tanya0806
Regular Visitor
6 years ago

Performance issue What If Parameter and DAX queries

We have a requirement where we need to take user input (around 30) and do the calculations based on this user input and render the report. For illustration purpose , consider a Product table having ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Please install DAX Studio.  Use the Performanc Analyzer in Power BI to isolate the measures/visuals that behave the worst, copy the query to DAX Studio, and examine the query plan.  Then decide how to optimize the measure. You want most of the work in the storage engine, and you want far fewer rows than you will likely see the first time. Rinse and repeat.