Forum Discussion

NumeroENAP's avatar
NumeroENAP
Icon for Helper III rankHelper III
6 years ago
Solved

TOPN by city

Hi,    I'm having problem with the use of TOPN, for some reason.    Here is an exemple of my model :  Employe City % John Buffalo 40% Julia Buffalo 38% Pedro San Jose 38% ...
  • NumeroENAP's avatar
    NumeroENAP
    6 years ago

    I succeeded! I used that formula : 

     

    TOP2RANK = CALCULATE(
           SUM('Table'[%]
                        );
                 TOPN(2;'Table';'Table[created_index];DESC
           )
    )
     
    Of course, I sorted my table with Power Query first.
TheDataMustFlow's avatar
TheDataMustFlow
Frequent Visitor
6 years ago

When you put the data in a matrix with the city as columns, do you get one or two columns for Minnesota?

If you get two it's probably because there's a trailing space in a row somewhere in your data in the city column.

 

Try to clean up your data (trim the city column) and see if the problem persists.

NumeroENAP's avatar
NumeroENAP
Icon for Helper III rankHelper III
6 years ago

I only have one column for minnesota and my datas are pretty clean 😞 

  • NumeroENAP's avatar
    NumeroENAP
    Icon for Helper III rankHelper III
    6 years ago

    I succeeded! I used that formula : 

     

    TOP2RANK = CALCULATE(
           SUM('Table'[%]
                        );
                 TOPN(2;'Table';'Table[created_index];DESC
           )
    )
     
    Of course, I sorted my table with Power Query first.