Forum Discussion
Solved
Need help with parameter
I have create a parameter named 'AssetID' I need to use the same parameter in my measure Per Asset = CALCULATE( AVERAGE('cbdb alarm_occurences'[qty_alarms_7day]), 'cbdb alarm_occur...
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...
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
-
As mentioned, I have added the table.But not able to access the same in my measure
after = symbol, you could use selectedvalue() for getting the value.
selectedvalue()Thank you!!!!! Working fine...