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 > 0Or Fields.ADDTL_REF > 0Or Fields.EXCISE_TAX > 0Or Fields.RECORDING_FEES > 0Or Fields.NON_STANDARD_FEES > 0)
You could use Or( , ) Dax function or use || symbol that used for or condition in DAX
Appreciate for Kudos
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.