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 all!
I'm trying to get a rank measure in order to get a TOP 5 in every hierarchy level in a visual.
For now I have four different columns with the corresponding Rank in every case of the Hierarchy level (Year-Quarter-Month-Day). I was just testing that the formula works, but cause I need to select the corresponding column based on a hierarchy, I can't make a simple "IF" column because it wouldn't react to the hierarchy drill.
So I tryed to make a measure with the same formula but I got stucked when the measure told me that I couldn't use the function EARLIER beacuse of the table context, so i need to repleace the formula with another fuction or something that let me do the same but without the EARLIER.
this is my first formula and if I solve this one i could solve the other ones without problem:
Hi @AlexGlz ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here. If you are still confused about it, please share some sample data.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AlexGlz ,
Maybe you could try the formula firstly. If it is not what you want, please share some sample data and expected results. Then we will understand clearly.
Year lvl Rank =
RANKX (
FILTER (
ALL ( 'LGE Block' ),
'LGE Block'[MCBF] <> 0
&& 'LGE Block'[From Date].[Year]
= MAX ( 'LGE Block'[From Date].[Year] ) - 1
),
'LGE Block'[MCBF],
,
ASC,
DENSE
)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |