Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I've been trying to find a solution with the below scenario. I hope someone can help.
I have the following data:
Name | Local Grade | Country |
Salameh, Mario | Partner | USA |
Berlin, Martin | Partner | USA |
Khan, Jawad | Partner | UK |
Mackenzie, Karl S | Senior Manager | Spain |
Masry, Raed A | Senior Manager | USA |
Ghanghro, Mossadiq A | Manager | Spain |
Bhatt, Mihir | Manager | UK |
Sobh, Mohamad A | Senior | Spain |
Hussein, Omar Z | Senior | USA |
Karmakar, Anirban | Junior | UK |
Mcpheator, Craig A | Junior | USA |
Zabalawi, Zaid H | Junior | Spain |
I have a slicer for Local Grade, and what I am trying to do is that when I filter on partners for example I want to see the percentage of partners in comparison to all other local grades for each country alone ( Not as a percentage of partners across all countries)
So If I select on Partner I should get the following:
USA 40 %
UK 33.3 %
Spain 0 %
What I did was that I used the following measure:
Solved! Go to Solution.
@Anonymous
Something like this may be
Measure = DIVIDE ( COUNT ( Table1[Country] ), CALCULATE ( COUNT ( Table1[Country] ), ALL ( Table1[Local Grade] ) ) )
@Anonymous
Something like this may be
Measure = DIVIDE ( COUNT ( Table1[Country] ), CALCULATE ( COUNT ( Table1[Country] ), ALL ( Table1[Local Grade] ) ) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |