Need help with parameter

[parvathisuku_90]

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_occurences'[grid_element_key]

        IN { "75e76b7c-19f3-4119-a043-859331e74c12" }
Instead of "75e76b7c-19f3-4119-a043-859331e74c12" I want use parameter AssetID

Can some please help

[nandukrishnavs · Accepted solution]

@parvathisuku_90 

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_90 · Accepted solution]

How can I convert parameter to table. Can you please provide an example.

[nandukrishnavs · Accepted solution]

@parvathisuku_90 

1. Open Edit Query window
2. Right-click on Parameter
   1. 
3. Click Reference
4. Then click on convert To Table
   1. 

[nandukrishnavs · Accepted solution]

@parvathisuku_90 

after = symbol, you could use selectedvalue() for getting the value.

selectedvalue() 

[nandukrishnavs · Accepted solution]

@parvathisuku_90 

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_90 · Accepted solution]

How can I convert parameter to table. Can you please provide an example.

[nandukrishnavs · Accepted solution]

@parvathisuku_90 

1. Open Edit Query window
2. Right-click on Parameter
   1. 
3. Click Reference
4. Then click on convert To Table
   1. 

[parvathisuku_90]

As mentioned, I have added the table.But not able to access the same in my measure

[nandukrishnavs · Accepted solution]

@parvathisuku_90 

after = symbol, you could use selectedvalue() for getting the value.

selectedvalue() 

[parvathisuku_90 · Accepted solution]

Thank you!!!!! Working fine...

[v-yiruan-msft]

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