Calculated AVG Line - show only one value

Hi  Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
SUMMARIZE('Table','Table'[Region],'Table'[Salesman])

2. Create calculated column.

Rank =
RANKX(FILTER('Table 2','Table 2'[Region]=EARLIER('Table 2'[Region])),'Table 2'[Salesman],,ASC)

3. Create measure.

Avg =
AVERAGEX(ALL('Table'),'Table'[Amount])

Measure =
var _region=SELECTEDVALUE('Table'[Region])
var _max=MAXX(FILTER(ALL('Table 2'),'Table 2'[Region]=MAX('Table 2'[Region])),[Rank])
var _maxSalesman=MAXX(FILTER(ALL('Table 2'),'Table 2'[Rank]=_max&&'Table 2'[Region]=_region),[Salesman])
var _allmax=MAXX(ALL('Table 2'),[Rank])
var _allmaxSalesman=MAXX(FILTER(ALL('Table 2'),'Table 2'[Rank]=_max),[Salesman])
return
    IF(
       HASONEVALUE('Table'[Region])&&
    MAX('Table'[Salesman])=_maxSalesman,[Avg],
    IF(
   NOT( ISINSCOPE('Table'[Region]))&&MAX('Table'[Salesman])=_allmaxSalesman,[Avg],
    BLANK()))

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly