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,
Can anybody explain what is the exact use of "Value" argument in RANKX Dax function with example?
Thanks,
-Arul
Solved! Go to Solution.
@Arul Well, the way it works is that the value parameter allows you to find the rank of that specific value within all of the values returned by the expression parameter. For example let's say that you have a table with three rows with values of 1, 2 and 3. If you did this:
@Arul Well, the way it works is that the value parameter allows you to find the rank of that specific value within all of the values returned by the expression parameter. For example let's say that you have a table with three rows with values of 1, 2 and 3. If you did this:
Not quiet getting it. Could you explain it bit more with some examples?
Many a times we have left out this value argument, So I am wondering why value argument is there in RANKX function.
Thanks,
-Arul
@Arul It is almost universally left out of RANKX formulas. I believe the concept behind it is that if you want to figure out the rank of a particular value within a range of values. For example, let's say that you have twelve months of aggregated, historical sales data and you wanted to determine the ranking of the most current month of sales data in comparison to this historical data. It almost certainly makes more sense used in a measure formula than for a calculated column but at the end of the day there aren't a ton of use cases for it in my opinion so it's hard to invent one.
To perhaps add additional confusion, consider that these two statements are equivalent:
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 |
---|---|
115 | |
101 | |
72 | |
68 | |
45 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |