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...
Thank you!!!!! Working fine...
Hi parvathisuku_90 ,
If the problem has been resolved, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.
Best Regards
Rena