Forum Discussion
SSAS query filter
When using member-filters, you have to select the full string of the element. So it's fast, but not flexible.
For searches like "Starts with..." you have to use Text filters, but then you pay the performance penalty. So try to reduce the imported data by using member filters first and continue with text filters (who will often not fold back).
This sounds as if your filters don't fold back to the server, so instead of filtering the data there and just pulling what's needed, load everything to PowerBI and filter there. SSAS-filters a bit sensitive, make sure you use Member-filters instead of Text-filters:
Thank you very much. It is working now. I did not know this trick before.
Do you know when we should use one or the other?
When using member-filters, you have to select the full string of the element. So it's fast, but not flexible.
For searches like "Starts with..." you have to use Text filters, but then you pay the performance penalty. So try to reduce the imported data by using member filters first and continue with text filters (who will often not fold back).
Hi,
I'm trying to apply the logic above when querying an SSAS cube using PowerQuery. However the date dimension includes several years and the member filter only comes back with a single value (2000) instead of all the available years - how can I expand the query to include multiple values? (There are no other filters applied in the powerquery, it is just using the date dimension as well)
Thanks
Dan