show individual IDs instead of their count

[Anonymous]

Hello, I have a measure that calculates the COUNT of IDs according to some filters.

What I need to do is to show these specific IDs as well, instead of only showing their count.

The measure that calculates the count (using COUNTROWS) is the following:

count of IDs=

VAR DateMonth = EOMONTH( MAXX( KEEPFILTERS( VALUES( MSR_PRD[DT] ) ), CALCULATE( MIN( MSR_PRD[DT] ) ) ), 0 )

VAR DatePreviousMonth = [Previous Month Last Date]

RETURN

COUNTROWS( CALCULATETABLE( VALUES( CPC[ID] ),

FILTER( ALL( MSR_PRD ),

MSR_PRD[DT] = DateMonth), CPC[DATE] > DatePreviousMonth ) )

How is it possible to show the specific IDs (CPC[ID]) not aggregated?

[Anonymous · Accepted solution]

I'm posting the solution that I got from @Fowmy  in a similar post I made:

IDs in month = 
CONCATENATEX(
    CALCULATETABLE( 
        VALUES( Table1[ID]),
        FILTER( 
            ALL( Calendar_table),
            Calendar_table[date] = some_date
        ),
        Table1[date] > another_date
    )   
,
Table1[ID],
 UNICHAR(10)
)

 Thank you both for your time and help @vanessafvg , @Fowmy 

[Anonymous]

still no luck with this @vanessafvg 

[vanessafvg]

you can create a calculated column?   not quite sure the point of the aggregation though if you want to show id's   unless you use them for different visuals

[Anonymous]

Hi Vanessa,

at first I only wanted the aggregation but now I also need the specific IDs as well.
Yes, it is for a different visual.

I don't understand how you mean to do it with a calculated column.

The measure I have calculates the Count according to the selections I make on several slicers I have on the page.

How could I do this with a calculated column though?
It seems simple but I have not found a way to do it after a lot of different approaches