Persisting DAX queries
In this post, I'm going to show you how to connect a tabular mode query to the cube it is sourced from - the question that I got asked by Marco Rus when I worked this out was :
Why? Why would you do that?
Well, there are a couple of reasons. If we think about SQL, we have the ability to persist a query that we have written, and then query it as if it was a table - our goal is to persist a DAX query, and enable users to use it as if it was a table - for instance, to use in a slicer. Unfortunately, in tabular, this really does mean persist - it's more like a materialised view than a view.