Why is my custom column not accepted as a filter?

[Typhoon74]

With this approach, I would like to exclude archived data from my report by only using one column to filter instead of 6 coming from related tables.

On my main data table,

I created new columns to retrieve the archive value 0 or 1 from related tables.
(Archived Area, .... Customer, .... Model, .... Component, .... Phase, .... Tests)

With an additional column (ARCHIVE) I am summarizing if any of the archived columns has a 1 it should have 1. This is working as expected.
The example below is is showing 1 on ARCHIVE because Archived Phases has a 1.

But now when using the ARCHIVE column on my report to filter, this is not excepted to filter the data. But when I use a column where the related data (Archived Phases) are in, that works.

Does anyone have an explanation for this?

[amitchandak]

@Typhoon74 , This should work, As this column can be 1 because of few other columns are 1, Are these ids have value =0 or 1 for the ARCHIVE column, check that first?

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Typhoon74]

@amitchandak yes these two IDs are having 1 for ARCHIVE

[amitchandak]

@Typhoon74 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.