Forum Discussion
Need help with parameter
I have create a parameter named 'AssetID'
I need to use the same parameter in my measure
Instead of "75e76b7c-19f3-4119-a043-859331e74c12" I want use parameter AssetID
You cannot directly use the parameter inside the DAX measure. But you can create a reference of the parameter. Then it will act as a table. After that, you can use it in DAX measure.
Attaching the PBIX file for your reference.
How can I convert parameter to table. Can you please provide an example.
- Open Edit Query window
- Right-click on Parameter
-
- Click Reference
- Then click on convert To Table
-
after = symbol, you could use selectedvalue() for getting the value.
selectedvalue()Thank you!!!!! Working fine...
7 Replies
- nandukrishnavsCommunity Champion
You cannot directly use the parameter inside the DAX measure. But you can create a reference of the parameter. Then it will act as a table. After that, you can use it in DAX measure.
Attaching the PBIX file for your reference.
- parvathisuku_90Helper I
How can I convert parameter to table. Can you please provide an example.
- nandukrishnavsCommunity Champion
- Open Edit Query window
- Right-click on Parameter
-
- Click Reference
- Then click on convert To Table
-