Forum Discussion

Clint's avatar
Clint
Icon for Helper V rankHelper V
7 years ago

Calculating Top N across columns

Hello,   I have a datasource that tracks initiatives and the projects that affect each initiative.  Each initiative is a column and each project is a row.  I've been asked to show a Top N (Top 3 In...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Clint
Icon for Helper V rankHelper V
7 years ago

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.