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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |