Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

How to pass parameter to a DAX Query

Hi all,

I am working on building a report that uses a Power BI Data Source. I need to be able to pass a parameter to the DAX Query. I am not able to get this to work. Any ideas how this is done?

 

Thank you!

 

Seyed

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Anonymous ,

 

To pass a parameter to a DAX query in Power BI, you can use the SELECTEDVALUE function. This function allows you to returns the value when the context for columnName has been filtered down to one distinct value only.

You can create a table and then bind a column field to your parameter. Binding a field to a parameter means that as the selected field value changes, the value passes to the parameter and updates the query that references the parameter.

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
avatar user
Anonymous
Not applicable

Syndicated - Outbound

Thank you so much Jianbo for your assistance!

v-jianboli-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Anonymous ,

 

To pass a parameter to a DAX query in Power BI, you can use the SELECTEDVALUE function. This function allows you to returns the value when the context for columnName has been filtered down to one distinct value only.

You can create a table and then bind a column field to your parameter. Binding a field to a parameter means that as the selected field value changes, the value passes to the parameter and updates the query that references the parameter.

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)