Max Skill Per Person

[Stanley18]

Hello, I'm a Power BI newbie and may have bitten off more than I can chew with creating this measure.  I have OA and other skills data for 8 staff (PF) and want to count the max OA skill for each PF then create a funnel chart.  Some sample data below shows person 1 has 2 OA skills (C &G) so I want to count them once as a max 2 and not in the level 1s and person 8 has 3 OA skills (M,G &C) where I want to count him once in the level 4 skill holders and not in the level 3s. I have created this in excel so I know what the answers should be but I can’t get the chart to show each person once in Power BI. Please shout if you need anymore context. Many thanks.

[Casperserven1]

@Stanley18  the answer is this!
Create a table 

Table 3 =

 CALCULATETABLE(

 SUMMARIZE (Data3, Data3[PF],  "maxrate", MAX(Data3[skill level])),

 FILTER( Data3, Data3[skillgroup] = "OA"))

This gives this result:
maxrate   PF

2	1
1	2
1	3
3	4
2	5
3	6
3	7
4	8

Now your issue is that you cannot add any other fields to this table such as Skill type as that will give you the max level against skill type. But you could join your original table with this one to be able to select by skill type if you needed. Dont believe that was your requirement though - a funnel chart with count of PF only existing at the highest skill level!!!!

[Casperserven1]

.....like this