Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
HI,
you can define a basic measure as
HI,
you can define a basic measure as
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |