topic Calculated Table with custom filtering in DAX Commands and Tips

Calculated Table with custom filtering

Mercovito — Wed, 25 Oct 2023 06:58:17 GMT

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

Re: Calculated Table with custom filtering

FreemanZ — Wed, 25 Oct 2023 08:20:48 GMT

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:

Re: Calculated Table with custom filtering

ThxAlot — Wed, 25 Oct 2023 09:05:23 GMT

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

Re: Calculated Table with custom filtering

Mercovito — Wed, 25 Oct 2023 09:43:09 GMT

MathXTC Thx A LOT

Re: Calculated Table with custom filtering

Mercovito — Wed, 25 Oct 2023 09:44:02 GMT

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