Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Dev13
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
Dev13
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
Dev13
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 

 

Dev13
Helper III
Helper III

still no luck with this @vanessafvg 

vanessafvg
Super User
Super User

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.