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

jbwestrock ,

Correct me if i midunderstood your question. From my understanding you are trying to build a calculated table with a list of filtered Business Units, if that is the case please refer below:

Create a calculated table with formula:

Cust_Table = 
SUMMARIZECOLUMNS (
    Sheet1[BUSINESS UNIT],
    FILTER (
        Sheet1,
        Sheet1[BUSINESS UNIT]
            IN {
            "B4266",
            "B4263",
            "B4356",
            "B4262",
            "B4342",
            "B4188",
            "B4264",
            "B4370",
            "B4327",
            "B4325"
        }
    )
)


BR