Forum Discussion

Jan845's avatar
Jan845
Icon for Helper I rankHelper I
3 years ago

Top5 values with more repeated values

 

 

Hi Sirs,

 

I create a TOP N with my ROOM column to show in one card the Name of the room that have more values repetead and i need other card to count the number of them but shows wrong values.

And i can't create a top 5 chart with top 5 of the rooms that repeat more times in the column when i selected filter PORTO show more than top 5 values and if i unselect the Porto filter shows only top 5 values...

 

 

 

My Table:

 

ROOMLOCALNUMBER OF REQUESTTYPE

123Lisboa31270OTHERS
132Lisboa16970ACCESS
132Porto31972SUPPORT
132Porto30565Internet
134Lisboa32851COMPUTER
134Lisboa29716INTERNET
134Lisboa19056PROJECTION
135Lisboa60503CAMERA
135Lisboa30206PROJECTION
144Lisboa22865CAMERA
EAA003Porto32891Zoom
EAA005Porto21342PROJECTION
EBI011Porto32858PROJECTION
EBI017Porto31173PROJECTION
EC015Porto32889CAMERA
EC112Porto30735COMPUTER
EP002Porto32890PROJECTION
EP004Porto22846OTHERS
ER207Porto29254PROJECTION
Room 11Lisboa19848ACCESS
Room 1221Lisboa23288INTERNET
Room 11Lisboa22518OTHERS
Room 11Lisboa22519PROJECTION
Room 1221Lisboa32484CAMERA
Room 1221Porto18458CAMERA

 

My PBIX file: WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free

 

Thanks for your help

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Jan845 ,

     

    The screenshot is too small to see.

    Can you share the expected result as well?

     

    Best Regards,

    Jay

    • Jan845's avatar
      Jan845
      Icon for Helper I rankHelper I
      3 years ago

      Without a filter 

       

      With Filter Porto dont show top 5 values

       

      And i have TOPN higer 5 with count room