Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi power BI comunity
I want to optimize the filters in my Power BI report to make it fast to code in and make it all run faster for the end user.
Now I can write a filter in DAX like this
Solved! Go to Solution.
here's a link to using NOT IN in Power BI Dax.
https://community.powerbi.com/t5/Desktop/DAX-equivalent-of-SQL-s-NOT-IN/m-p/586192#M277794
You can use Power Bi's built in Performance Analyzer to test various measure speed.
Does this solve your problem?
here's a link to using NOT IN in Power BI Dax.
https://community.powerbi.com/t5/Desktop/DAX-equivalent-of-SQL-s-NOT-IN/m-p/586192#M277794
You can use Power Bi's built in Performance Analyzer to test various measure speed.
Does this solve your problem?
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |