Table with Rankx, how to display detail in separate table

[ssbagley]

2/6/23 update:  Sample2.pbix 

I updated and simplified the Rankx, but I still cannot get the table below to tie out to the rank table or display the details. 

Sample.pbix 

Link to sample data above.

In the sample, there are three tables with Ranking measures - one with Amount, one with Count and one with Count and Amount.  My preference would be that the table underneath display the detail behind the Count & Amount, but I would be happy if it would display any of them.  Currently, I cannot get the detail table to tie to a ranking table. 

I've tried only ranking by amount, but the detail shows 100%, rather than just the ranked items.  Help!

[ssbagley]

updated main post on 2/6

[Ashish_Mathur]

Hi,

Your requirement is just not clear.  What result are you expecting in the second table.  Show that clearly. 

[ssbagley]

I expect the Detail table (at bottom) to tie to any one of the options above.  

For the screenshot below, I would expect the detail table to total $2225.00 and only contain Jack, Bob and Jessica's submissions.

[grantsamborn]

Hi @ssbagley 

I took a quick at a few of the measures and after formatting, something jumped out about your ranking measures.

Can you explain the last part when you divide X by X.

Ranking by Amount = rankx (all (Expenses[Emp Name]),[Sum Amount], ,DESC) * DIVIDE([Top N by Amt],[Top N by Amt])

Ranking by Count = rankx (all (Expenses[Emp Name]),[Count of Amount], ,DESC) * DIVIDE([Top N by Count],[Top N by Count])

/**************************************************/

Ranking by Amount =
RANKX(
    ALL( Expenses[Emp Name] ),
    [Sum Amount],
    ,
    DESC
)
    * DIVIDE(
        [Top N by Amt],
        [Top N by Amt]
    )

/**********************/

Ranking by Count =
RANKX(
    ALL( Expenses[Emp Name] ),
    [Count of Amount],
    ,
    DESC
)
    * DIVIDE(
        [Top N by Count],
        [Top N by Count]
    )

Any comments?

[ssbagley]

I'm open to improvements! I borrowed it from another solution when trying to answer my questions. 

[ssbagley]

I changed the security on the link so anyone can edit (I think!)