- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you so much Jianbo for your assistance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-03-2024 01:36 PM | |||
04-25-2024 09:25 AM | |||
09-06-2024 04:23 AM | |||
09-05-2024 10:50 AM | |||
06-19-2024 08:28 PM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |