DAX measure that limits the maximum amount for another measure

[JoseHebron]

I have an existing measure that calculates a gross-profit percentage (GP%).

I would like to create a new measure (GP%Max) that limits the GP% value.

Example:

GP%Max =

IF GP% < -999 then GP%Max = -999

ELSE

IF GP% > 999 then GP%Max = 999

ELSE

GP%Max = GP%

Thanks for your help!

[selimovd]

Hey @JoseHebron ,

you can do that with a combination of SWITCH and TRUE:

GP%Max =
SWITCH(
    TRUE(),
    [GP%] < -999, -999,
    [GP%] > 999, 999,
    [GP%]
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[JoseHebron]

Thanks for your reply:

When I do that, this is what I get...