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 (whi...
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.

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.

HS_PDS's avatar
HS_PDS
Frequent Visitor
6 years ago

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