cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

## How to find least contributors to a pool overtime.

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

1 ACCEPTED SOLUTION
Resident Rockstar

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]
)
``````

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

2 REPLIES 2
Resident Rockstar

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]
)
``````

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Resident Rockstar

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors