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!