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.
hello i need some help to create a new colum with placements for people. i use a measure to let the point everybody has to calculate but i want a placement in a order by the measure of points. if made a exaple beneath to show how the data looks like i how i want the colum. i use a measure to get the points the teams Scored the measusre i use is: "
Placement (i need to create this colum) | Name | team |
1 | Roy | AZ |
1 | Roy | Go Ahead Eagles |
1 | Roy | Psv |
1 | Roy | Feyenoord |
2 | klaas | Ajax |
2 | klaas | PSV |
2 | klaas | Feyenoord |
so i want the person that has the most points get placement 1 then placement 2 etc etc
Solved! Go to Solution.
Hi @Krijgerss21 ,
Please try:
Placement =
IF (
ISINSCOPE ( 'Uitslagen Tour de France'[Name] ),
RANKX (
ALLSELECTED ( 'Uitslagen Tour de France' ),
CALCULATE (
SUM ( 'Uitslagen Tour de France'[Punten] ),
ALLEXCEPT ( 'Uitslagen Tour de France', 'Uitslagen Tour de France'[Name] )
),
,
DESC,
DENSE
)
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @Krijgerss21 ,
Please try:
Placement =
IF (
ISINSCOPE ( 'Uitslagen Tour de France'[Name] ),
RANKX (
ALLSELECTED ( 'Uitslagen Tour de France' ),
CALCULATE (
SUM ( 'Uitslagen Tour de France'[Punten] ),
ALLEXCEPT ( 'Uitslagen Tour de France', 'Uitslagen Tour de France'[Name] )
),
,
DESC,
DENSE
)
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @Krijgerss21 ,
Please try:
Placement =
IF (
ISINSCOPE ( 'Uitslagen Tour de France'[Name] ),
RANKX (
ALLSELECTED ( 'Uitslagen Tour de France' ),
CALCULATE (
SUM ( 'Uitslagen Tour de France'[Punten] ),
ALLEXCEPT ( 'Uitslagen Tour de France', 'Uitslagen Tour de France'[Name] )
),
,
DESC,
DENSE
)
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |