Forum Discussion

EMaker's avatar
EMaker
Regular Visitor
1 year ago
Solved

IF OR Dax Measure

Hi,   Does anyone know how I can write the below Excel formula into a DAX Measure i'm struggling to select information for Column D2  as it keeps providing a function instead of the column.  =IF(...
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    1 year ago

    Hello EMaker,

     

    Can you please try this approach:

    CalculatedMeasure = 
IF(
    OR(
        MAX(Table[I]) >= MAX(Table[D]),
        ISBLANK(MAX(Table[D]))         
    ),
    0,                                  
    5 * MAX(Table[E])                   
)
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

EMaker 

If you're trying to create a DAX measure:

Measure Formula = 
SUMX(
YourTable,
IF(
OR(YourTable[I] >= YourTable[D], FALSE), 
0, 
5 * YourTable[E]
)
)

If you want to create a calculated column:

Calculated Column Formula = 
IF(
OR(YourTable[I] >= YourTable[D], FALSE), 
0, 
5 * YourTable[E]
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn