Forum Discussion

HS_PDS's avatar
HS_PDS
Frequent Visitor
6 years ago
Solved

Slicer Parameter to count measures

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 

 

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.