Automating to Show Goal Met and Calculate Payouts

[lamccra5]

Hello, I am working on automating something that was previously in Excel. I would like to insert a goal, mid goal, and max goal and then take the actual current number and have PowerBi tell me if what goal has been met.

[Anonymous · Accepted solution]

Hi @lamccra5 ,

@khaledHabib90 , good answer! And here is my solution.

Performance Category = 
VAR Selected_Value = SELECTEDVALUE(Parameter[Parameter])
RETURN
IF(
    ISBLANK(Selected_Value),
    BLANK(),
    IF(
        Selected_Value < 60,
        "non-performance",
        IF(
            Selected_Value <70,
            "goal",
            IF(
                Selected_Value < 90,
                "mid goal",
                "max goal"
            )
        )
    )
)

goal = 60, mid goal = 70, max goal = 90.
The results are as follows:

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

[khaledHabib90]

It should be something like the below, very similar to excel BTW

Create a calculated column, not a measure, using the below

Switch(true(),

Actuals >= max , "Max",

Actuals >= mid && actuals < max, "Mid",

Actuals >= goal && actuals < mid, "goal met",

"Goal not met")

If my reply helped you solve the issue, please accept it as the solution 🙂