Forum Discussion
Power BI effiency problem
Hi, Im having a problem with the Power BI solution i have being too slow. Basically i have a data sets ranging from 50 000 rows to 1 000 000 rows, for which it might take 20min to perform the que...
You need an inverse slicer. Luckily, I invented one.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325
You may also need an inverse aggregator. In that case:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266#M91