How to use IF-Statement in a measure to adjust values based on condition

[qwertzuiop]

Dear Power BI Community

I am at a loss at the moment.

Following problem:

Let's assume following tabel:

We have diffrent Checks (A, B, C, D...) - to reduce complexity, we only talk about a and b

Done is (0,1) weather the check is done

Planed is always (1)

A summarised table shows the following:

Check A has 4 "Done" of 12 "Planed"

Check B has 2 "Done" of 10"Planed"

means we have an achievement level of 6 out of 22

NOW to the main problem:

Le'ts assume we want to adjust the plan downwards like this for Check "A"

I did this by following measures:

Check A (adjusted by half) =
CALCULATE(SUM('table1'[Planed]),

FILTER('table1', ('table1'[Check] = "A" ))) / 2

Plan_Adjust =

IF( MIN('table1'[Check]) = "A", table1[Check A (adjusted by half)],

SUM(table1[Planed]))

If it's just one Check selected i works as expected

But when both Checks are selected we get the MIN (6) instead of the SUM (16)

I know there's a problem using the "MIN"-Statement in the measure, but i dont find any alternative.
Any ideas how to solve the problem?

Thank you very much for your contribution

Cheers
qwertzuiop

[tamerj1 · Accepted solution]

Hi @qwertzuiop 

please try

Plan_Adjust =
SUMX (
    VALUES ( table1[Check] ),
    CALCULATE (
        VAR NormalValue =
            SUM ( table1[Planed] )
        VAR AdjustedValue = NormalValue / 2
        RETURN
            IF ( MIN ( 'table1'[Check] ) = "A", AdjustedValue, NormalValue )
    )
)

[amitchandak]

@qwertzuiop , Try a measure like

Sumx(values('table1'[Check]) , IF( MIN('table1'[Check]) = "A", table1[Check A (adjusted by half)],

SUM(table1[Planed])))