Need to use If Condition In Power BI Desktop.

Hi arvindyadav,

 

Since this is a measure the value of it changes accordingly to context, so when making the average Profit/Employee you need to change it filter context.

Without additional information it's hard to give you a correct answer but you need to create something like this:

 

Pofict per employee =
IF (
    SUM ( Table[Profit] )
        > CALCULATE ( [Average Profit/Employee]; ALL ( Table[Employee] ) );
    SUM ( Table[Profit] );
    CALCULATE ( [Average Profit/Employee]; ALL ( Table[Employee] ) )
)

If you can share some sample data and expected result this measure can be made inline with your expectactions, again without any data difficult to respond.

 

Regards,

MFelix