Slicer Parameter to count measures

[HS_PDS]

I want to create a parameter that a slicer passes to measures, which in then perform counts.

Basically I have a few metrics and want to count in a column which fall under a certain threshold (which is passed thru slicer)

Here is an example:

I have three metrics and column which counts if metric is under threshold. These are then totaled in the fires column. 

For example the first row has one metric under 40% so would calculate as 1 fire

I havent figured out the threshold bit any help is appreciated.

Is this even possible? Let me know if I'm not clear or you need more examples/ clarification 

[v-juanli-msft · Accepted solution]

Hi @HS_PDS 

Create what-if parameter and creat measures

Metric1_cnt = IF(MAX('Table'[Metric1])<[Parameter Value],1,0)

Metric2_cnt = IF(MAX('Table'[Metric2])<[Parameter Value],1,0)

Metric3_cnt = IF(MAX('Table'[Metric3])<[Parameter Value],1,0)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HS_PDS]

@v-juanli-msft   Thank you for the work-around , This worked beautifully! 

[mussaenda]

Hi @HS_PDS ,

you can create a parameter. you can find it in modeling tab, Create parameter.

If you need more help, provide a sample data that can be copied and show your desired output when a parameter is used.

Thanks.