Forum Discussion

Helper I

5 years ago

Solved

Change Value with Slicer // dynamic Value

Hello everyone, I am facing a big problem and I hope that someone here can help me with their expertise. I have created a report that compares a certain price, which is entered by the responsible depa...

Need Help

v-yingjl

5 years ago

Hi Power_MN ,

Use what-if parameters and try to create measures like this:

Initial rank = 
RANKX(
    ALL('Table'),
    CALCULATE(SUM('Table'[Price])),,DESC,Dense
)


New Rank = 
IF(
    SUM('Table'[Price]) > 'Price reference'[Price reference Value], [Initial rank],
    RANKX(
        FILTER(
            ALL('Table'),
            'Table'[Price] <= 'Price reference'[Price reference Value]
        ),CALCULATE(SUM('Table'[Price])),,DESC,Dense
    )
)

Attached a sample file in the below, hopes it could help.

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

rank.pbix27 KB

v-yingjl

Community Support

5 years ago

Hi Power_MN ,

Use what-if parameters and try to create measures like this:

Initial rank = 
RANKX(
    ALL('Table'),
    CALCULATE(SUM('Table'[Price])),,DESC,Dense
)


New Rank = 
IF(
    SUM('Table'[Price]) > 'Price reference'[Price reference Value], [Initial rank],
    RANKX(
        FILTER(
            ALL('Table'),
            'Table'[Price] <= 'Price reference'[Price reference Value]
        ),CALCULATE(SUM('Table'[Price])),,DESC,Dense
    )
)

Attached a sample file in the below, hopes it could help.

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

rank.pbix27 KB

Power_MN

Helper I

5 years ago

v-yingjl

Works great! Thank you so much!

Kind regards and stay healthy!

Michael