Skip to main content
Microsoft Idea

Power BI

New

Ability to use Parameter fields in RANKX function

Vote (1) Share
Niels Henrik Nielsen's profile image

Niels Henrik Nielsen on 03 Oct 2022 07:17:10

In general I think we could get much more functionality out of Paramater Fields if we could refere to these Parameter Fields in some of our existing functions eg. in the RANKX function


Today the RANKX function requires these parameters: RANKX(Table, Expression, Value, Order, Ties)


But it could be a really nice functionality if both the Table and Expression could refere to the Parameter Fields you have created e.g.


RANKX(all("Parameter field selected"), "Parameter measure selected",,DESC)


The Parameters Fields creates a lot of nice flexibility in our dashboards and we could probably get much more out of Parameter Fields if we could use them in functions like RANKX and probably also in other Functions.