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.
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi NumeroENAP 

try new calculated table

 

Table 2 = 
ADDCOLUMNS(
SUMMARIZE('Table';'Table'[City];"%";MAX('Table'[%]));
"Employee";
LOOKUPVALUE('Table'[Employe];'Table'[City];[City];'Table'[%];[%])
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn