Question on Blog Deep Dive into Query Parameters and Power BI Templates RRS feed

  • Question

  • There is one screen shot in this blog that is not clear enough for me to read what is being done and I was wondering if the person who wrote the blog would be able to tell me what is says.  It is the graphic after this paragraph....

    After Query Parameters have been referenced from other queries as needed, users can hit “Close & Apply” in the Query Editor ribbon to get their data and parameters loaded into the data model. At that point, they can start creating the report and even reference these parameters from DAX expressions, such as the one in the following screenshot.

    Any help with this would be appreciated.

    Thank you,


    Wednesday, December 6, 2017 9:08 PM


  • Hi Pamela,

    Here's what I got from Miguel:

    This was just pulling the one-row value (i.e. Country parameter value).

    Measure = "Customers from " & FIRSTNONBLANK(Country[Country], true)


    Thursday, December 7, 2017 1:00 AM