Calculated column to find most repeated value

[Anonymous]

Hi, need some help on a calculated column to get the column 4 "result - most visited" based on column 1& 3 (name, visited). the result has to be the most repeated value in column 3(visited) for that particular name.

Appreciated for your help

Thanks

Table:

name   month   visited    result - most visited

mike	Jan	LA	Dallas
mike	Jan	Dallas	Dallas
mike	Jan	Austin	Dallas
mike	Feb	Dallas	Dallas
Dan	march	NJ	NJ
sam	Jan	NY	LA
sam	march	LA	LA
sam	march	LA	LA

sam

march

Austin

LA

[Anonymous]

@Anonymous Here is my approach

First create a calculated column to get the count of visit by name and visited

VisitCount = CALCULATE(COUNT('Table'[Visited]),ALLEXCEPT('Table','Table'[Name],'Table'[Visited]))

Then create a measure to get the name of city

Measure = 
VAR _max = CALCULATE(MAX('Table'[VisitCount]),ALLEXCEPT('Table','Table'[Name]))
RETURN CALCULATE(MAX('Table'[Visited]),FILTER(ALLEXCEPT('Table','Table'[Name]),'Table'[VisitCount]=_max))

[Anonymous]

Would give the solution if I could, this worked for me.

Thanks.