Forum Discussion
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?
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?
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
5 Replies
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.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/823601Hi 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
