topic Re: List of values in a column in DAX Commands and Tips

List of values in a column

Kapcer — Mon, 19 Sep 2022 14:51:42 GMT

This is my dax formula. In var possibleplayers I want to filter the playerinfo table to only return players with a certain position. I tried using Filter, Values, AllEXCEPT but they return tables.I need a function or a combination that returns a list of values from a column like ALL but unlike ALL can be filltered.

Re: List of values in a column

Greg_Deckler — Mon, 19 Sep 2022 14:57:41 GMT

Kapcer Try:

VAR PossiblePlayers = SELECTCOLUMNS(FILTER(ALL(playerInfo[ID]),[position] = "something"),"ID",[ID])

Re: List of values in a column

v-yueyunzh-msft — Tue, 20 Sep 2022 02:07:11 GMT

Hi, Kapcer

According to your description, you want to return the value of a column of a table. Right?

You can use the FILTER function to filter your table first, then use the SELECTCOLUMNS() function to get a column in that table to generate a new table, like this :

PossiblePlayers = SELECTCOLUMNS(FILTER(ALLSELECTED(playerInfo[ID]),[position] = "your filter condition"),"ID",[ID])

This expression returns a single-column table, and you can use the STATIC() or VALUES() functions for deduplication, or iteratively evaluate using maxX() or MINXX() functions.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: List of values in a column

Kapcer — Wed, 21 Sep 2022 08:57:50 GMT

Thanks for trying to help, those solutions didn't work. I didn't find one that solves this issue but I achived the result I wanted in a different way.