How to make calculated column based on filtered table

[Anonymous]

Hi,

I'm new to Power BI and have a single excel spreadhseet.
I have the code for a filter which I used in a measure to get the number of expected rows and its comes through correctly.

The filtered code is in the format "FILTER(Database,Expression)"

I want to be able to make a calculated column for my data table where every row that is present in the Filtered datatable is shown as 1, else 0.

Th current code I used is:

IF(CONTAINS(FILTER(Database,Expression),random_column_name,random_column_name),1, 0)

However, that is making every row in the table as 1 instead of just the filtered datatable I expect. Any help is greatly appreciated. Thanks!

[amitchandak · Accepted solution]

@Anonymous , if you want to display data to reduce, you need to create a measure and use that in the table visual along with other columns

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

[Anonymous]

Thanks for replying, that solved my issue! To anyone else who does not want to show the measure (where measure is the Filter formula) next to the column table in the visual, you can also filter the data table based on the created measure and say 'if measure is equal to 1' and lock the filter.