Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I have created a parameter using manage parameter option form edit queries. But I want to call that parameter in a measure, so I created a blank query and I am trying write this syntax
As you can see I have named my parameter on right hand side as "Select Measure"
so when I write a syntax in blank query like this
let
Source = #table({“MeasureParameter”},{{#”Select Measure”}})
in
Source
It gives me Invalid Identifier error. over this section
I have no idea what is happeneing, My actual parameter is on right side of syntax, so what is first part which I have highlighted?
I think its just a random name by which that parameter will be called.. I need help on this..
I am following this article
http://community.powerbi.com/t5/Desktop/Passing-Parameters-in-measures/m-p/208276
Thanks in advance.
Solved! Go to Solution.
Hi @Bhavana_PB,
Please try it like this. I would suggest you avoid using spaces in the parameter names. Then you can use the parameter name directly.
let Source = #"Select Measure" in Source
Best Regards,
Dale
Hi @Bhavana_PB,
Did it help? Can you mark it as an answer?
Best Regards,
Dale
Hi,
Sorry for late reply, yes its working for me.
Thank you
Bhavana
Hi @Bhavana_PB,
Please try it like this. I would suggest you avoid using spaces in the parameter names. Then you can use the parameter name directly.
let Source = #"Select Measure" in Source
Best Regards,
Dale
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
78 | |
77 | |
59 | |
36 | |
33 |
User | Count |
---|---|
100 | |
62 | |
56 | |
48 | |
41 |