Forum Discussion
Solved
Power BI RANKX Issue Summary - Get an average rank for decimal numbers
I am trying to calculate an average rank based on Views_Share_Avg, while considering both Channel and Daypart and excluding the selected date. However, I am running into issues where: RANKX does n...
Hello RedJedi_81,
Thank you for reaching out to the Microsoft Fabric Forum Community.
I’ve reproduced your scenario in Power BI using the sample data, and I achieved the expected output as per your requirements.
Output:For your reference, I’ve attached the .pbix file below so you can review or modify it as needed.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Thank you for the quick reply.
I forgot to add Rank2 is a column. Does this need to be a measure?