cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Measure to calculate all values where values column A > specified filter value

Two columns:

Iteration Path    Remaining work

101                      5

101                      6

102                      8

103                      4

103                      6

104                      12

How to create a measure where the filter on Iteration path returns all Remaninng work of the selected Iteration path + all higher iteration Paths?

Example: Filter Iteration Path = 102    ==>   Remaining Work = 8 + 4 + 6 + 12 = 30

Example: Filter Iteration Path = 103    ==>   Remaining Work = 4 + 6 + 12 = 22

1 ACCEPTED SOLUTION
Community Support

Hi  @RemkoS  ,

Here are the steps you can follow：

1. Create a measure.

``````Measure =
CALCULATE(
SUM('Table'[Remaining Work]),
FILTER(ALL('Table'),[Iteration Path]>=MAX([Iteration Path])))``````

2. Result.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi  @RemkoS  ,

Here are the steps you can follow：

1. Create a measure.

``````Measure =
CALCULATE(
SUM('Table'[Remaining Work]),
FILTER(ALL('Table'),[Iteration Path]>=MAX([Iteration Path])))``````

2. Result.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

Add this as a measure, Place a slicer for Iteration Path

``````Total Remaining Work =
CALCULATE(
SUM(Table4[Remaining work]),
FILTER( ALL(Table4[Iteration Path]) , Table4[Iteration Path] >= SELECTEDVALUE( Table4[Iteration Path] ))
) ``````

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors