Forum Discussion

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

amitchandak , only few rows, what I want is to exclued PM_ORDER_SYSTEM_TYPE that include CLSD from only PLANNED Rev_Group.

 

PM_ORDER_SYSTEM_STATUSPM_ORDER_USER_STATUSTotal_HoursStatusDisplayedRev_Group
CNF,NMAT,PRC,PRT,SETCE115CLSDFalsePLANNED
TECO,PCNF,DLFL,NMAT,PPRT,PRC,SETCE190CLSDFalseCOV-HLD2
CLSD,NMAT,PRC,SETCCANC1CANCFalsePLANNED
CLSD,CNF,CSER,GMPS,MACM,PRC,PRT,SETCE186CLSDFalseCOV-CAN
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Is below column what you need?

    Here is the dax expression:

     

    Column = 
var _check=SEARCH("CLSD",'Table'[PM_ORDER_SYSTEM_STATUS],1,0)
Return
IF('Table'[Rev_Group]="PLANNED"&&_check=1,BLANK(),'Table'[Rev_Group])

     

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!