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 , 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
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.
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
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
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |