Forum Discussion
Top N by value with Year parameter
Hi, ephilip004
https://msdn.microsoft.com/pt-br/library/gg492185(v=sql.120).aspx
Use-of-rankx-in-power-bi-measures
Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
Best Regards,
Rfranca
I tried using the Rankx function but it returned 1 for every row, since it is counting the number of wells for each well. I want to aggregate by operator first, then only looking at 2016 and 2017, determine the top 25 operators by well count. I have created another Excel file manually ranking the operators for the correct years from a pivot table, but I would like to know if it is possible to do straight through Power BI.
If you are already using visual filters, can you use the same for Dates?
You need to select 'Adavance' filter. See image below.
Hi,
Share the link from where i can download your PBI file. Also, show the expected result there.
Here is the link to the report:
Hi,
I cannot download the file from that link.
