DAX to retrive a value from multiple column based on condition.

[Novice100]

Hello Community,

I need help in writing a DAX for retrieving a value from multiple column based on condition.

For example from column "Name" i need to select only Alice and display the sum of "Salary" and "Bonus" in column "Total"

Thanks in advance,

Saurav

[amitchandak · Accepted solution]

@Novice100 , New measure 

= sum(Table[Salary])  + Sum(Table[Bonus])

If you need you column

Sumx(filter(Table, [Name] + earlier([Name]) ) , [Salary] +[Bonus])

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Total CC =
VAR _condition = Data[Name] = "Alice"
RETURN
    ( Data[Salary] + Data[Bonus] )
        * DIVIDE ( _condition, _condition )

[amitchandak · Accepted solution]

@Novice100 , New measure 

= sum(Table[Salary])  + Sum(Table[Bonus])

If you need you column

Sumx(filter(Table, [Name] + earlier([Name]) ) , [Salary] +[Bonus])