Forum Discussion

Khushboo9966's avatar
Khushboo9966
Icon for Helper II rankHelper II
2 years ago
Solved

DAX Calculated measure verification

The following is the Calculated column DAX I am using.  a) App Role is joined to App in a many-to-one relationship.    Level 1 = IF( 'App'[TBUS] <= 24 &&  (TRUE) 'App'[NE] = "Existing",  (TRUE)...
"dax code"
"DAX"
@powerbi
Need Help -DAX Measures
  • Khushboo9966's avatar
    Khushboo9966
    2 years ago

    I cannot merge tables since this is direct query.

     

    Level 1a = IF(
  ('App'[Total] <= 24) && ('App'[App Purpose] = "Purchase" || 'App'[App Purpose] ="Refinance"),
  IF(CALCULATE(COUNTROWS('App Role'), 'App Role'[Applicant Type]= "Individual" && 'App Role'[Role] = "PB") > 0  ,1,0),0)

     The below formula did the trick for me.  

DallasBaba's avatar
DallasBaba
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

Khushboo9966 let use CALCULATE function

Level 1 =
IF(
    'App'[TBUS] <= 24 &&
    'App'[NE] = "Existing",
    IF(
        CALCULATE(
            COUNTROWS('Application Role'),
            'App Role'[Role] = "PB" &&
            'App Role'[App Type] = "Individual"
        ) > 0,
        1,
        0
    ),
    0
)

The CALCULATE function filters the 'Application Role' table based on the specified conditions and counts the rows that meet those conditions. If the count is greater than 0, it returns 1; otherwise, it returns 0.

Let me know if this work
@ me in replies, or I'll lose your thread!!!