Forum Discussion
Rank
Hi I am having one column in table named [MeasureId] and [Earnings] is the Calculated measure. I have calculated Rank of Earning using RANKX function but for last 5 rows [Earnings] is same and th...
I mean to say as per Slicers Year, Client, the number of rows coming from table may vary. so for example if I select Client = 23 and Year = 2018 from slicer then, there could be only 5 'Measure'[MeasureId] may return whereas if I select Client=24 and Year=2017 then say may be 4 rows with 'Measure'[MeasureID] will return. And that's why I want to create Measure instead of column.
Anonymous,
It seems that the table 'Measure'[MeasureID] locates in is dynamic, I doubt if it is possible to create a rank measure in this case. Could you please share sample data of the table that includes year and client fields?
Regards,
Lydia