Measure only works when I apply filter , is there a way to get it working not using slicer

[Pandadev]

Hi , I need to have a measure that groups the output  by region.

So I get the top rank list for each region , my measure is only working when I select a region from the slicer.

I would like it to work , without having to apply any slicer filters if possible

FTK Region Rank 2019 =
MINX (
FILTER (
SELECTCOLUMNS (
ALLEXCEPT( A_List ,A_List[region]),
"index", A_List[19 FTK World Rank],
"rank", RANKX ( ALLSELECTED ( A_List ), A_List[19 FTK],, DESC, DENSE )
),
[index] = MAX ( A_List[19 FTK World Rank] )
),
[rank]
)

Desired output would be

Code    Region    Rank     RPK

AA         EUR        1          5000

AB         EUR         2         3000

AC         EUR         3         1000

AD         MDE       1          4000

AE         MDE        2          2000

[v-henryk-mstf]

Hi @Pandadev ,

You can try formula like below:

RANK_ =
RANKX (
    FILTER ( ALL ( 'Table' ), 'Table'[Region] = EARLIER ( 'Table'[Region] ) ),
    [RPK],
    ,
    DESC
)

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

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

[Pandadev]

Thanks , yes that has fixed the ranking code , my last issue is trying to apply the same logic to my coverage code , is this also possible

Finance Region Coverage 2020 = SUM([20 Rev USD])/CALCULATE(SUM(A_List[20 Rev USD]),ALLEXCEPT( A_List ,A_List[region]))

[Pandadev]

Here is an example table

code	Region	Value
AAA	MDE	1000
BBB	EUR	900
CCC	EUR	800
DDD	MDE	700
EEE	EUR	600
FFF	NOA	500
GGG	NOA	400
HHH	MDE	300

I need a formula to create the world coverage and region coverage in same table visual so the results are like this 

code	Region	Value	Region Cov	World Cov
AAA	MDE	1000	0.5	0.192308
BBB	EUR	900	0.391304	0.173077
CCC	EUR	800	0.347826	0.153846
DDD	MDE	700	0.35	0.134615
EEE	EUR	600	0.26087	0.115385
FFF	NOA	500	0.5556	0.096154
GGG	NOA	400	0.4444	0.076923
HHH	MDE	300	0.15	0.057692

So for the world coverage the total value is 5200 , I am dividing the value of the row by the total value of the row

For the regional coverage for MDE the total value is 2000 

AAA	MDE	1000
DDD	MDE	700
HHH	MDE	300

I am dividing the value by 2000

For NOA it is 900

and EUR is 2300