Formula is adding all results to one cell instead of individual lines

[dezmondh]

Hello,

I have a formula measure that allows me to see which projects were removed compared to the previous period. The problem is that it puts all the results in one cell rather than listing them out so I can add other columns.

Can anyone advise on how to fix this? Thank you...

Screenshot and formula found below.

Removed =

var _table = FILTER(ALL('Table1'), NOT('Table1'[Project ID]) in SELECTCOLUMNS(FILTER(ALLSELECTED('Table1'),'Table1'[Rank] = EARLIER('Table1'[Rank])+1),"1",'Table1'[Project ID]))

return

CONCATENATEX(

FILTER(_table,[Rank]=MAX('Table1'[Rank])-1),[Project ID],",")

[lbendlin]

Measures can only return scalar values, they cannot return lists or tables. What you did is the best you can do with measures.