Forum Discussion
Need new calc column counting all rows with same value in column but not for entire table
- 7 years ago
Hi zamboni1199,
It seems that you may filter the report with the date slicer.
If it is your case, you could create the calculated column with the measure below.
Column = COUNTROWS ( FILTER ( 'Table1', EARLIER ( 'Table1'[Employee] ) = 'Table1'[Employee] && 'Table1'[Date].[Month] = EARLIER ( Table1[Date].[Month] ) ) )Here is the result output.
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Hi zamboni1199,
It seems that you may filter the report with the date slicer.
If it is your case, you could create the calculated column with the measure below.
Column =
COUNTROWS (
FILTER (
'Table1',
EARLIER ( 'Table1'[Employee] ) = 'Table1'[Employee]
&& 'Table1'[Date].[Month] = EARLIER ( Table1[Date].[Month] )
)
)
Here is the result output.
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Thank you, that was great!