cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Cummulative with measure not working

I'm trying to create a cummulative calcule but it's not working.

I've created 1 measure with Earned Value which is Earned Value = ([Planned Value BAC] * [Total of % Complete]) / 100

and then I created the

EV cummulative = CALCULATE([Earned Value], FILTER(ALLSELECTED(Budget),Budget[account_period] <= MAX(Budget[account_period])))

the result is diplayed below and the total is right, but it doesn't follow the sum. I've created also BAC cummulative and Actual cost cummulative and both works.

1 ACCEPTED SOLUTION
Helper I

I have to create a column Earned Value instead of a measure.

then the code below worked.

EV cummulative = CALCULATE([Earned Value], FILTER(ALLSELECTED(Budget),Budget[account_period] <= MAX(Budget[account_period])))

4 REPLIES 4
Helper I

I have to create a column Earned Value instead of a measure.

then the code below worked.

EV cummulative = CALCULATE([Earned Value], FILTER(ALLSELECTED(Budget),Budget[account_period] <= MAX(Budget[account_period])))

Super User

Tough to understand what is going on given the information provided. I take it that [Planned Value BAC] and [Total % Complete] are also measures? What are their formulas? What is the value of [Total % Complete] in the rows show below? What are your formulas for the cummulative totals that work?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Helper I

Hi Greg,

Both are measures with SUM function.

Planned Value BAC = IF(SUM(Budget[budget_rev])<>0, SUM(Budget[budget_rev]), BLANK())

Total of % Complete = SUM(Budget[% Complete])

This measure below works

BAC cummulative = CALCULATE([Planned Value BAC],FILTER(ALLSELECTED(Budget),Budget[account_period] <= MAX(Budget[account_period])))

Community Support

Hi @ftorres,

You formula seems well, can you please share a pbix file with some sample data for test?

In addition, you can also try to use following measure to calculate cumulative based on other measure:

```Commulative =
VAR currPeriod =
MAX ( Budget[account_period] )
VAR summary =
ADDCOLUMNS ( ALLSELECTED ( Budget ), "EV", [Earned Value] )
RETURN
SUMX ( FILTER ( summarize, Budget[account_period] <= currPeriod ), [EV] )
```

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Announcements

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

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors