Forum Discussion

rsbin's avatar
rsbin
Community Champion
2 years ago
Solved

Numeric Range Parameters

Hello Folks, Using Parameters for the first time and struggling with some logic: I have a simple Numeric Range Parameter which represents "Driver Wait Time (s)"  - from 0 - 180 incremented by 1. ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rsbin 

    Based on your description, you can refer to the following solution.

    Sampple data 

    The paramater table is the same as you privided.

    Create a measure.

     

     

    MEASURE =
CALCULATE (
    SUM ( 'Table'[Overall Driver Wait] ),
    'Table'[Overall Driver Wait]
        > SELECTEDVALUE ( 'QueueTimeThreshold(sec)'[Parameter] )
)
)

     

     

    Then put the measure to the visual.

    Output

     

     

    Best Regards!

    Yolo Zhu

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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rsbin 

Based on your description, you can refer to the following solution.

Sampple data 

The paramater table is the same as you privided.

Create a measure.

 

 

MEASURE =
CALCULATE (
    SUM ( 'Table'[Overall Driver Wait] ),
    'Table'[Overall Driver Wait]
        > SELECTEDVALUE ( 'QueueTimeThreshold(sec)'[Parameter] )
)
)

 

 

Then put the measure to the visual.

Output

 

 

Best Regards!

Yolo Zhu

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

 

rsbin's avatar
rsbin
Community Champion
2 years ago

Anonymous , Ashish_Mathur 

Apologies for the delayed response.  I got dragged into another project.

Thank you both for providing the solution.  Ashish, Driver Wait is actually a column in my Fact Table so I simply went with Yolo's solution.  But understand both solutions are driving at the same thing and now understand the logic.

Kind Regards to you both,