9 thoughts on “Creating a Dynamic, Parameterized Measure in DAX

  1. Hi,
    I saw that this post was made in 2014, and saw that there was a possibility that you would make the power pivot model, would this be available for dowload?

  2. Any chance that you could make this Excel workbook available for download? I see some visualization and DAX techniques that I’d like to study.

    1. HI, Chris. This particular example was added to a rather large SSAS tabular model. When I get some time, I’ll do my best to replicate the technique in a small Power Pivot model for download.

      1. hi Paul , thanks for sharing you experiences with us , can i uses this it SSAS tabular model

      2. Absolutely. I prototype a lot of DAX & tabular modelling solutions in Power Pivot first and then move them into SSAS Tabular. The design experience is going to be so much better in 2016. So excited to see that coming.

  3. If you were going to learn one and only one language, DAX or MDX, which one would you choose and why?

    1. That’s a big question and the answer would depend on a few factors. If you are working in an organization with an existing investment in SSAS multidimensional or if you have business requirements that warrant building cubes, MDX is the language you’ll need to know. If you will be creating or supporting SSAS tabular or Power Pivot models, you should learn DAX. The demand for tabular/DAX skills are smaller right now but growing where MDX skill are in demand but I don’t expect that demand to grow over time.

Leave a Reply

%d bloggers like this: