Forum Discussion

snaydeck's avatar
snaydeck
New Member
9 years ago
Solved

HELP URL IMAGE TOP N - No have idea

(HELP URL IMAGE TOP N - No have idea)   I need to make a grid with product photos (using Image Viewer) by Employee.   I need to bring the url of the "image product" column.   I select the desir...
Need Help
Show and Tell
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    9 years ago

    Hi snaydeck

    To solve the tie break, I can think of following strategy

     

    With the tie break, lets assume that Lowest Product ID will be Ranked Higher i.e. following desired result

    employeeproduct_idsum_qtyimage_productrank
    A1111100img/qwe.jpg1
    A2222100img/asd.jpg2
    A333360img/zxc.jpg3


    Add a Calculated Column (which only affects the Qty in decimals)

    Dummy Qty =
Table1[sum_qty]
    - Table1[product_id] / 10000


    Then use above Column to RANK.

    Revised Rank =
RANKX (
    FILTER (
        Table1,
        Table1[employee] = EARLIER ( Table1[employee] )
            && Table1[Dummy Qty] >= EARLIER ( Table1[Dummy Qty] )
    ),
    Table1[Dummy Qty],
    ,
    ,
    DENSE
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
9 years ago

Hi snaydeck

Add a caculated Columm to your table

Rank =
CALCULATE (
    COUNT ( Table1[sum_qty] ),
    FILTER (
        Table1,
        Table1[employee] = EARLIER ( Table1[employee] )
            && Table1[sum_qty] >= EARLIER ( Table1[sum_qty] )
    )
)

This will range images for each employee.

Now insert a slicer for RANK and Employees.

To select Top 2 you would then have to select 1 and 2 both from the RANK slicer

Hope this helps

snaydeck's avatar
snaydeck
New Member
9 years ago

Hi my friend Zubair_Muhammad. Thanks Again for try to help me like the usual.

 

So I create the column with Rank, it worked fine, but I have a problem.

 

When the numbers are the same.

 

Example, let's assume that in row one 40 is 100 now.

 

 

employeeproduct_idsum_qtyimage_product
A1111100img/qwe.jpg
A2222100img/asd.jpg
A333360img/zxc.jpg

 

employeeproduct_idsum_qtyimage_productrank
A1111100img/qwe.jpg2
A2222100img/asd.jpg2
A333360img/zxc.jpg3

 

I'm without TOP 1 (rank with the number 1)

 

Is there a way to solve this?

 

It is very important that it comes without duplicate rank.

 

I have two other columns that can serve as a tiebreaker, if necessary. Column X (number) and column Y (date).

 

If you can help me, thank you so much!

 

Thanks man!!!

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Hi snaydeck

     

    In that case, if you use the formula below then RANK 1 would not be skipped.
    But then there would be 2 items with Rank 1

    Rank =
RANKX (
    FILTER (
        Table1,
        Table1[employee] = EARLIER ( Table1[employee] )
            && Table1[sum_qty] >= EARLIER ( Table1[sum_qty] )
    ),
    Table1[sum_qty],
    ,
    ,
    DENSE
)

     

    You will get

    employeeproduct_idsum_qtyimage_productrank
    A1111100img/qwe.jpg1
    A2222100img/asd.jpg1
    A333360img/zxc.jpg2
    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Hi snaydeck

      To solve the tie break, I can think of following strategy

       

      With the tie break, lets assume that Lowest Product ID will be Ranked Higher i.e. following desired result

      employeeproduct_idsum_qtyimage_productrank
      A1111100img/qwe.jpg1
      A2222100img/asd.jpg2
      A333360img/zxc.jpg3


      Add a Calculated Column (which only affects the Qty in decimals)

      Dummy Qty =
Table1[sum_qty]
    - Table1[product_id] / 10000


      Then use above Column to RANK.

      Revised Rank =
RANKX (
    FILTER (
        Table1,
        Table1[employee] = EARLIER ( Table1[employee] )
            && Table1[Dummy Qty] >= EARLIER ( Table1[Dummy Qty] )
    ),
    Table1[Dummy Qty],
    ,
    ,
    DENSE
)