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 your can modify the DAX formula

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

 

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

 

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

DallasBaba Already tried, Did not work in the False case.