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],", ")
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...