Forum Discussion

bbwong's avatar
bbwong
Helper I
5 years ago
Solved

Calculated Column Flag - 2nd Condition

I'm using the below with success however would like to add a 2nd condition to Agreement Status.   How can I add a 2nd condition of Agreement Status of "Draft" to share the same "Current/Draft Agree...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    bbwong 

    Try the following measure:

    CURRENT/DRAFT AGREEMENT FLAG = 
VAR _A =
CALCULATE (
MAX ( 'Table3'[Client Id] ),
FILTER ( ALLEXCEPT ( 'Table3', 'Table3'[Client Id] ), 'Table3'[Agreement Status] IN {"Current","Draft"} ))
RETURN
IF ( _A <> BLANK () && HASONEVALUE(Table3[Client ID]), "Current/Draft Agreement", " " )

     

     

     



Fowmy's avatar
Fowmy
Super User
5 years ago

bbwong 

Try the following measure:

CURRENT/DRAFT AGREEMENT FLAG = 
VAR _A =
CALCULATE (
MAX ( 'Table3'[Client Id] ),
FILTER ( ALLEXCEPT ( 'Table3', 'Table3'[Client Id] ), 'Table3'[Agreement Status] IN {"Current","Draft"} ))
RETURN
IF ( _A <> BLANK () && HASONEVALUE(Table3[Client ID]), "Current/Draft Agreement", " " )

 

 

 



bbwong's avatar
bbwong
Helper I
5 years ago

Thanks - that worked.