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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NarcisOne
New Member

DAX measure with multiple IFs

Hello,

Please can you help me to write this DAX measure in Power BI?

I have 5 columns with multiple combinations (A - E) and F column which summarize the columns A - E.

I need to obtain the result from column "RESULT" and I don't know what formula should I use. 

Thank you for your support.

 

ifs.PNG

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I correctly understood your question, but please check the below picture and the attached pbix file whether it suits your requirement.

 

Jihwan_Kim_0-1667567855906.png

 

 

 

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I correctly understood your question, but please check the below picture and the attached pbix file whether it suits your requirement.

 

Jihwan_Kim_0-1667567855906.png

 

 

 

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Thank you! It works just fine.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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