Forum Discussion
Show only specific rank from table
Hi everyone, I'm rather new to Power BI and was wondering whether there is function to only show a specific rank of a table based on a measure. E.g. I want to create a podium with 1st 2nd and 3r...
Try
Rank = RANKX( ALL(constructors), [Points] )
It is, but I can still not use it as a Filter
johnt75
Super User
Super Userat what level are you applying the filter, page or visual? because it will only work at visual level. SQL BI have an interesting article on measures as filters
I am applying the filter at visual level. Is it possible to get a calculated column for the Rank Function instead of a measure?
If so, what would it be if thats my measure?
Rank = RANKX(ALL(constructors[Name]),[Points])- johnt75
I think that that code would also work for a calculated column, but bear in mind that it will not be affected by any slicers or filters, so you could not for example choose a date range
Unfortunately it does not work..