cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

show individual IDs instead of their count

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?

1 ACCEPTED SOLUTION
Helper III
Helper III

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 

 

View solution in original post

4 REPLIES 4
Helper III
Helper III

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 

 

View solution in original post

Helper III
Helper III

still no luck with this @vanessafvg 

Super User I
Super User I

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors