Forum Discussion
parvathisuku_90
5 years agoHelper I
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...
- 5 years ago
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.
- 5 years ago
How can I convert parameter to table. Can you please provide an example.
- 5 years ago
- Open Edit Query window
- Right-click on Parameter
-
- Click Reference
- Then click on convert To Table
-
- 5 years ago
after = symbol, you could use selectedvalue() for getting the value.
selectedvalue() - 5 years ago
Thank you!!!!! Working fine...
nandukrishnavs
5 years agoCommunity 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.