Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Novice100
Frequent Visitor

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

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"

 

Capture.PNG

 

Thanks in advance,

Saurav

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Novice100 , New measure 

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

 

If you need you column

 

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

View solution in original post

Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

Picture2.png

 

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

Picture2.png

 

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


amitchandak
Super User
Super User

@Novice100 , New measure 

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

 

If you need you column

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors