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 : No it doesn't work. I get the below error:

"This expression refers to a Column object named 'Application[Test]', which has an error."

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

    Khushboo9966 Do you have a table name 'Application'

    Or are you trying to refere to 'Application Role' [Test]' before getting the error message ?

    More also, can you share  a pbix file of your work sample

      • 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.