How to find the name of the largest value (by most counts) when selecting filter?

[Anonymous]

Hi all,

I am working on a dataset and I would like to create a measure (or multiple measures) to identify the top counts for job title when I filter by countries.

How do I transform the data above into the example below? When I click on the country, I want to automatically show the best performing job titles? 

Thank you!

Ashley

[Anonymous · Accepted solution]

HI,

you can define a basic measure as

# Rows = COUNTROWS('Table')

and then build your main measure:

Top Performing Job Title = CALCULATE(MAX('Table'[Job Title]),TOPN(1, 'Table', [# Rows]))

Regards

Lorenzo

[Anonymous]

Hi supergimi,

Thank you for your swift response! It seems like the measure wouldn't change according to the filter value. Can I ask for your advice on this?

Thanks again! 

Ashley

[Anonymous]

Hi,

in my sample .pbix, built on data you show in the first post, the measure work with filter.

If you are testing your model with the same data, keep attention on the fact that for France, you have 3 occurrencies for Directors, CIO and IT Manager and not a real TOP1 job title. So I try changing the source data a little.

      

Regards

Lorenzo