Forum Discussion

czuniga's avatar
czuniga
Helper III
6 years ago

Dynamic Parameter

I have a parameter I am trying to create in order to determine the revenue associated with a dynamic number of customers. This formula gives me all of the revenue rather than limiting it to the numbe...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi czuniga ,

 

We can create a measure as below to work on it.

Measure = 
VAR a =
    ADDCOLUMNS (
        'Table',
        "rank", RANKX ( ALL ( 'Table' ), 'Table'[value],, DESC, DENSE )
    )
RETURN
    SUMX ( FILTER ( a, [rank] <= Parameter[Parameter Value] ), 'Table'[value] )

 

Pbix as attached.