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
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
User | Count |
---|---|
456 | |
147 | |
123 | |
53 | |
53 |
User | Count |
---|---|
444 | |
129 | |
113 | |
77 | |
72 |