Calculated Table with custom filtering

[Mercovito]

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 excluded as all factories of Company C is Inactive. So new table will only have Company A, B and C

Can you please help?

Here, you can see the PBIX file.

https://drive.google.com/file/d/1zxp-Ln_e3Mzmzkefe68h5OWO76kQY2EH/view?usp=sharing

[ThxAlot]

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

[Mercovito]

@MathXTC Thx A LOT

[FreemanZ · Accepted solution]

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:

[Mercovito]

Thank you so much; I need to burn my brain to understand this step by step 🙂