Performance Improvement

[Anonymous]

Hi All,

Let us assume i have 100 rows of data and i want to show data for 1 department alone in front end visualization that contains 20 rows.

Now i have to option

1. To create a measure and in that dax i can put Calculate(Sum([Sales]),Department="A") and drag it in chart

2. To restrict in Visual level filter.

Which one is good for performance improvement in direct query mode as well as in import mode?

Thanks in Advance

[Anonymous · Accepted solution]

HI @Anonymous,

Maybe you can take a look at following links about tricks to improve performance:

Optimization guide for Power BI 

A comprehensive guide to Power BI performance tuning 
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous ,

You should use calculate in case of direct query.

[Mariusz]

Hi @Anonymous 

They are the same, do what's easier to maintain ( CALCULATE is going to perform exactly the same operation )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn