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.  

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Khushboo9966 ,

 

According to your statement, I think you can try code as below to update [Level1] calculated column.

Level 1 NEW = 
VAR _PBLIST =
    CALCULATETABLE (
        VALUES ( 'App Role'[Role] ),
        FILTER (
            'App Role',
            'App Role'[App ID] = EARLIER ( App[App ID] )
                && 'App Role'[Applicant Type] = "Individual"
        )
    )
RETURN
    IF (
        ( 'App'[Total] <= 24 )
            && ( 'App'[App Purpose] = "Purchase"
            || 'App'[App Purpose] = "Refinance" ),
        IF ( MAXX ( FILTER ( 'App Role', "PB" IN _PBLIST ), 1 ) > 0, 1, 0 ),
        0
    )

 Result for you sample is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.