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.
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.