Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 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))
Would give the solution if I could, this worked for me.
Thanks.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |