Efficiency difference between a DAX filter and visual level filter

[JohnF1966]

Does anyone know if it's more efficient (from a performance/speed perspective) to write filters directly with DAX in a measure or to drag the columns to the visual level filter and filter from there?

For the exact same filter will visuals update quicker using one method versus the other?

I believe that the Power BI engine converts the visual level filter to a DAX expression, but I'm not sure if that expression is more efficient than writing a DAX filter expression directly in a measure. I'm also curious if the conversion process the engine needs to perform on a visual level filter to create a DAX expression affects performance.

Are there any articles about this?

[mwegener]

Hi @JohnF1966 

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[v-diye-msft · Accepted solution]

Hi @JohnF1966 

I believe below posts could be your reference:

https://community.powerbi.com/t5/Desktop/Report-filter-vs-DAX-FILTER/td-p/190317 

https://community.powerbi.com/t5/Desktop/TopN-in-Visual-Level-Filter-vs-TopN-DAX/td-p/660409 

[amitchandak]

This is one running document from Microsoft. I do not think it is covering the question you asked yet. But still for the reference

https://docs.microsoft.com/en-us/power-bi/guidance/

Appreciate your Kudos.
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[mwegener]

Hi @JohnF1966 ,

Performance is a difficult topic and usually there is no general statement.  ("It depends ...")

This might interest you.

https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[parry2k]

@JohnF1966 great question, don't remember anything on top of head. May be you want to test this using  DAX STudio by writing filter directly in a measure or using filter in filter pane.