Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter from 2 different columns

Hi Team, I need to create a filter from 2 different columns. I want a filter from Colum Active_Status and Inactive_Status. I need to give user a filter with Available and Not Active.   IP Add...
Need Help
  • jaideepnema's avatar
    jaideepnema
    5 years ago

    If you only want Available and not active then create a column like this:

     

    Status Check = SWITCH(TRUE(),
    'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="Not Active","Available not active",blank())

     If you want Active, In Active and Available  and In Active create a column like this:

    Status Check = SWITCH(TRUE(),

    'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="","Available",

    'Table'[Active_Status]="" && 'Table'[Inactive_Status]="Not Active","Not Active",

    'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="Not Active","Available not active")

     

jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
5 years ago

Anonymous 
change the DAX as given below:

Status Check = SWITCH(TRUE(),

'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="","Available",

'Table'[Active_Status]="" && 'Table'[Inactive_Status]="Not Active","Not Active",

BLANK())
 
 

Please accept this a solution if your question is answered 

Appreciate a kudos !!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    jaideepnema ,

    I want Available and Not active, if I chane the DAX for 

    Status Check = SWITCH(TRUE(),

    'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="","Available",

    'Table'[Active_Status]="" && 'Table'[Inactive_Status]="Not Active","Not Active",

    BLANK()).

     Irrespective of anything in Active_Status Column it should only pick Inactive.

    There may be case where it has 2 status in Each colum but I want only Available and Not_Active

    • jaideepnema's avatar
      jaideepnema
      Icon for Solution Sage rankSolution Sage
      5 years ago

      If you only want Available and not active then create a column like this:

       

      Status Check = SWITCH(TRUE(),
      'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="Not Active","Available not active",blank())

       If you want Active, In Active and Available  and In Active create a column like this:

      Status Check = SWITCH(TRUE(),

      'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="","Available",

      'Table'[Active_Status]="" && 'Table'[Inactive_Status]="Not Active","Not Active",

      'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="Not Active","Available not active")