Need help with using parameter in measure

[parvathisuku_90]

How can I use a Parameter in measure 

Per Asset = CALCULATE(

    AVERAGE('cbdb alarm_occurences'[qty_alarms_7day]),

    'cbdb alarm_occurences'[grid_element_key]

        IN { "75e76b7c-19f3-4119-a043-859331e74c12" }

need to pass "75e76b7c-19f3-4119-a043-859331e74c12" as a parameter.

Can someone please help!!

[v-stephen-msft · Accepted solution]

Hi @parvathisuku_90 ,

We cannot use a parameter in a measure directly. To work around this requirement, we could create a query to store parameter value in a dataset, and then use this dataset value in your calculated measure. Please refer to the sample steps below.

1.Create a parameter in the Power Query Editor.

2.Create a blank query and edit the query in Advanced Editor.

3.Create a measure in your original table like below.

Per Asset = CALCULATE(

    AVERAGE('cbdb alarm_occurences'[qty_alarms_7day]),

    'cbdb alarm_occurences'[grid_element_key]=Max(Query1[Parameter]))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@parvathisuku_90 , Try like

calculate(AVERAGE('cbdb alarm_occurences'[qty_alarms_7day]),
'cbdb alarm_occurences'[grid_element_key]
IN { "75e76b7c-19f3-4119-a043-859331e74c12" })

[parvathisuku_90]

This code is working perfectly

Per Asset = CALCULATE(

    AVERAGE('cbdb alarm_occurences'[qty_alarms_7day]),

    'cbdb alarm_occurences'[grid_element_key]

        IN { "75e76b7c-19f3-4119-a043-859331e74c12" }

But, my requirement is to pass "75e76b7c-19f3-4119-a043-859331e74c12' as a parameter to the measure. "75e76b7c-19f3-4119-a043-859331e74c12" is a sample value. I want to change this with the help of parameter.