How to find least contributors to a pool overtime.

[TheBaz_57]

Hi there,

We have a pool with several contributors in it. The total sum of the pool value has descreased overtime. How can I find which contributor(s) had the largest drop of the pool value overtime ?

Below is an example on how our data looks like, and it runs over two years and have 5,000 contributors. The date column is a full date column the is hierarchied. 

i.e

In Jan we know the pool value was 1,750,000, in Mar 1,210,000. How to find which contributor is the most responsible of this reduced value ? Thanks 😁

Contributor	Date	Value of contributor in pool
Bob	Jan 2022	1,000,000
	Feb 2022	500,000
	Mar 2022	860,000
Steve	Jan 2022	600,000
	Feb 2022	700,000
	Mar 2022	300,000
Henry	Jan 2022	150,000
	Feb 2022	75,000
	Mar 2022	50,000

[ChrisMendoza · Accepted solution]

@TheBaz_57 -

You could do something like:

Bottom Contributor Value = 
CALCULATE(
    [Total Value],
    FILTER(
        TableName,
        RANKX(
            TableName,
            [Total Value],,
            ASC,
            Dense
        ) = 2
    )
)

Bottom Contributor = 
CONCATENATEX(
    FILTER(
        TableName,
        RANKX(
            TableName,
            [Total Value],,
            ASC,
            Dense
        ) = 1
    ),
    TableName[Contributor]
)

[ChrisMendoza]