Forum Discussion

jbwestrock's avatar
jbwestrock
Frequent Visitor
4 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
    4 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
4 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
4 years ago

That worked in my test model.  Putting it in actual model.

 

Thank you!