Forum Discussion
Top N by value with Year parameter
Hi all, I'm new to the Power BI community and DAX so I may be missing something simple here. I have a table with different metrics tracked for different oil wells across time. Fields include a uni...
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.
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.
Do you have Power BI Pro? I can share access via email if you give me your contact info. Otherwise what should I use to share the file?