Forum Discussion
Helper VCalculating Top N across columns
Helper VHello Anonymous ,
To clarify, I need to calculate the Top N across values in multiple columns, not just one. I have something like 7 columns representing various attributes and each row in the dataset is a project name. I need to find the Top N (3) of project name count from all 7 columns; meaning which three 3 columns have the highest number of projects associated to them.
- Clint
Hello Anonymous ,
Here is a dummy of what the table structure looks like (removing proprietary info)
Project Name Status Close Reason Micro Stage Gate Date Created Closure Date Variance Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9 Column10 Project 1 Open 1 1 1 1 1 1 project 2 In progress 1 1 1 1 Project 3 Closed 6/30/2019 1 1 1 1 1 Project 4 Open 1 1 1 1 Hi Clint,
What I understood after looking at your dummy data is that, you want the summation of all the count in each column for all your projects and identify the highest summation for each of these columns.
Correct me if I am wrong.
if What i undersood is correct, then can you show the table somethign like this??
This is because Power BI support doesn't support multiple Top N in Visual level filters.
May be you need a Calculated column.
you can refer this post :
https://community.powerbi.com/t5/Desktop/TOPN-for-two-columns/td-p/545097
Thanks,
Tejaswi
- Clint
Thanks Anonymous , I just created a couple of tables in excel to pull the data together in the way I needed it to do the Top N. The datamodel of the source just needs to be restructured I think to give us more flexibility in working with it.