Forum Discussion

Mercovito's avatar
Mercovito
Frequent Visitor
2 years ago
Solved

Calculated Table with custom filtering

Hello Masters I am trying to filter my table with DAX and create a new table. I want to exclude companies from the main table those all factories are Inactive. Below picture; "Company C" should be ...
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi Mercovito ,

    Not sure if i fully get you, try to create a calculated table like:

    Table = 
CALCULATETABLE(
    sheet1,
    FILTER(
        VALUES(sheet1[Company]),
        "Active" IN  CALCULATETABLE(VALUES(sheet1[Factory Active - Inactive]))
    )
)

    it worked like:

     

ThxAlot's avatar
ThxAlot
Super User
2 years ago

 

Table =
FILTER(
    DISTINCT( Sheet1[Company] ),
    NOT ISEMPTY(
        CALCULATETABLE( Sheet1, Sheet1[Factory Active - Inactive] = "Active" )
    )
)