It is quite simple to display value by using filters so this article is not about that but about how to do it using a DAX formula using a measure. I will use this example:

The goal is to display values of the “number” column based on the criteria “type”, “category” or both. The formula with 1 criteria:

CONCATENATEX(FILTER('table','table'[argument1]="criteria"),'table'[argument2],", ")

NOTE: instead to separate the value with a coma, just replace “,” by whatever you want.

For my example, it shows all “number” according to the “type” = “yes”. The result:

The formula with 2 criterias or more:

CONCATENATEX(FILTER('table',
'table'[argument1]="criteria1"
&&'table'[argument2]="criteria2"),
'table'[argument3],", ")

NOTE: to add another criteria, just add “&&'table'[argument]="criteria")” below the line of “criteria1”.

For my example, it shows all “number” according to the “type” = “yes” and “category” = “a”. The result:

And to end, the formula combining “and” (&&) and “or” (||) conditions:

CONCATENATEX(FILTER('table',
'table'[argument1]="criteria1"
&&('table'[argument2]="criteria2"||'table'[argument2]="criteria3")),
'table'[argument3],", ")