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