Forum Discussion

jbwestrock's avatar
jbwestrock
Frequent Visitor
3 years ago
Solved

CALCULATETABLE with multiple filters

Hello,   I am trying to create a new table from a much larger existing table, with only the filtered rows.  I have tried a few different versions of CalculateTable and other work arounds mentioned ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jbwestrock ,

    Step 1: Under reporting go to modelling and click on create new table


    Step 2: Enter this into formula

    Unique_Table = 

SUMMARIZECOLUMNS (
    Sheet2[BUSINESS_UNIT],
    Sheet2[EMPLID],
    Sheet2[REG_REGION],
    Sheet2[EMPL_TYPE],
    FILTER (
        Sheet2,
        Sheet2[BUSINESS_UNIT]
            IN {
            "B4263",
            "B4266"
        }
    )
)

     
    Step 3: Unique table that you an amend


    BR , if that helps please mark this as a solution

jbwestrock's avatar
jbwestrock
Frequent Visitor
3 years ago

Sorry for the confusion. 

 

I am trying to create a unique table with only the data for this specific list of business units.  I want all columns in the other table, but only for the rows that include data for these business units.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    jbwestrock ,

    In that case are you able to share the sample data set with maybe 10 rows and sensitive data removed?

    BR

    • jbwestrock's avatar
      jbwestrock
      Frequent Visitor
      3 years ago

      Below is rough data, as much as I could get into the character max.

       

      Thank you