Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table with the following values:
Id Price
--------------------
1 50
2 70
3 60
4 55
5 65
I am trying to rank this table using a measure but I get an error "a single value for the column "Price" cannot be determined. The formula is as follows:
Measure = RANKX(ALL(Data[Id]),[Price]).
Where am i going wrong.
Solved! Go to Solution.
Hi @CBaisako
Add a CALCULATE and SUM around the [Price]
Measure = RANKX(ALL(Data[Id]),CALCULATE(SUM(data[Price])))
and have a read of this blog on using RANKX in measures http://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Hi @CBaisako
Add a CALCULATE and SUM around the [Price]
Measure = RANKX(ALL(Data[Id]),CALCULATE(SUM(data[Price])))
and have a read of this blog on using RANKX in measures http://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |