[HELP NEEDED] Changing a formula generating a table expression into one generating a column expres

[Anonymous]

I want to be able to use VALUES or DISTINCT with FILTER.

A lot of workarounds (i.e. Calculatetable + Filter or SELECTCOLUMNS + Filter) dont work as the output is still a TABLE expression. 

I need the output to be a COLUMN expression, so I can use it in some other formulas like "search".

Does anyone know how to convert a TABLE expression into a COLUMN expression?

I have a long workaround involving creating the actual filtered calculatedtables but its very ineffiecient and due to the nature of my work, would not be feasable (so solutions cannot involve me creating a separate calculatedtable)

[v-xuding-msft]

Hi @Anonymous ,

Can you please share some sample data and expected results? It is better to create a new calculated column formula based on the request than convert expression directly.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly share your solutions. More people who have the same problem will benefit from here. If you are still confused about it, please share more details to us. 

Best Regards,

Xue Ding

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

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490