Filter text DAX column

[thhmez7]

Hi,

kind of simple question:

How can I create a new text column with DAX in which it's filtered by another text column. I don't want to use the filter in the filterpane, but in the new column.

For example

Account names that have the filter Status = Active.

thank you

[v-luwang-msft · Accepted solution]

Hi @thhmez7 ,

According info your provided,pls refer the following sample:

sample data:

Dax for new column:

New Status = CALCULATE(MAX('Table'[Account]),
       FILTER(ALL('Table'),
         'Table'[Account]=EARLIER('Table'[Account])&&'Table'[Status]="Active"))

Fianl output result:

If you want to dynamically filter,I suggest you use measure and visual:

New Status1 = CALCULATE(MAX('Table'[Account]),FILTER(ALL('Table'),'Table'[Account]=MAX('Table'[Account])&&'Table'[Status]="Active"))

Final output:

Did I answer your question? If so ,pls mark my post as a solution,if not ,could you pls share your sample data and expected output result.Remember to remove confidential data.

Best Regards
Lucien

[mh2587]

col = Calculate(account name ,tablename[satus]="Active")