Forum Discussion

3 Replies

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