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

Anonymous's avatar
Anonymous
Not applicable
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

Thanks for the info - so I just need to list all the column names ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Yes, thats right.

    If it helps , please mark this as a solution ğŸ™‚

    BR