How to measure most frequent record in a column ?

[karun_r]

Let's say I have a table with the below schema

CREATE TABLE [dbo].[ARCG](
	Sub [nvarchar](400) NULL,
	UserName [nvarchar](200) NULL,
	[UserRole] [nvarchar](200) NULL,
	[Action] [nvarchar](200) NULL,
	[UserUpdatedBy] [nvarchar](200) NULL,
	[UserUpdatedOn] [datetime] NULL
) ON [PRIMARY]

GO

Sample data would be something like thi

Sub1    User1    Admin    Granted    Add1    2017/07/07
Sub2    User2    Admin    Granted    Add1    2017/07/06
Sub1    User3    Admin    Granted    Add2    2017/07/07
Sub3    User1    Admin    Granted    Add1    2017/07/07
Sub3    User2    Admin    Granted    Add2    2017/07/06
Sub3    User3    Admin    Granted    Add1    2017/07/07

In my report, I have slicer on UserUpdatedOn field and if I select dates including 2017/07/07 and 2017/07/06, "Add1" should be returned as it has most frequency in the column UserUpdatedBy column. Similarly, the value should change when I adjust the slicer. Is there any way to do this using Measures ?

[karun_r · Accepted solution]

Found the answer in this post. Marking as sovled.