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?
Solved! Go to 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
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
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
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
Check out new user group experience and if you are a leader please create your group
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
User | Count |
---|---|
387 | |
204 | |
79 | |
78 | |
66 |
User | Count |
---|---|
452 | |
221 | |
129 | |
87 | |
81 |