Forum Discussion

JohnF1966

Kudo Collector

6 years ago

Solved

Efficiency difference between a DAX filter and visual level filter

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?...

Need Help

v-diye-msft
6 years ago
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

Super User

6 years ago

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-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Forum Discussion

Efficiency difference between a DAX filter and visual level filter

Related content

Cost efficiency?

Efficient development with lean reports and huge Semantic Model

Different schema into different destination

Efficient way to conditionally transform nested tables with different structures.

Improving data refresh efficiency