Need to use If Condition In Power BI Desktop.

Hi arvindyadav,

Again is a question of context, since the measure is based on the total profit value compared with the average you are getting the total profit and not the sum of the above values you need to do a SUMX statment something like this should work:

IF (
    HASONEVALUE ( Table[Employee] );
    IF (
        SUM ( Table[Profit] )
            > CALCULATE ( [Average Profit/Employee]; ALL ( Table[Employee] ) );
        SUM ( Table[Profit] );
        CALCULATE ( [Average Profit/Employee]; ALL ( Table[Employee] ) )
    );
    SUMX (
        Table;
        IF (
            SUM ( Table[Profit] )
                > CALCULATE ( [Average Profit/Employee]; ALL ( Table[Employee] ) );
            SUM ( Table[Profit] );
            CALCULATE ( [Average Profit/Employee]; ALL ( Table[Employee] ) )
        )
    )
)

Regards,

MFelix