cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Google5ive
Frequent Visitor

DAX 'If' statement with 'or' conditions

What if you have a multiples tables that need produce a Sum only if they have a value above 0 for example and I know this code isnt correct but im trying to explain

 

Calculate( Sum(
if Column 1 > 0,

if Column 2 > 0,

if Column 3 > 0)

 

 

How would I write something in the proper format in DAX

 

since i cant use if statements

 

This is what im trying to convert into DAX

 

SUM(iif((Fields.ADDTL_INST > 0
Or Fields.ADDTL_REF > 0
Or Fields.EXCISE_TAX > 0
Or Fields.RECORDING_FEES > 0
Or Fields.NON_STANDARD_FEES > 0)

2 REPLIES 2
MahyarTF
Solution Sage
Solution Sage

Hi,

You could use Or( , ) Dax function or use || symbol that used for or condition in DAX

Appreciate for Kudos

MahyarTF_0-1660185367043.png

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.