- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-23-2017 02:09 AM

Hey guys,

I need to make a line chart with monthly cumulative values for a measure I made. The measure tells me how many projects were finished on time (%).

The measure is below:

On time = DIVIDE (

CALCULATE ( COUNT ( baseLIC[On time?] ); baseLIC[On time?] = "Yes" );

CALCULATE ( COUNT ( baseLIC[On time?] ); ALLSELECTED(baseLIC[On time?]) )

)

Not sure the usual sumx or calculate suggestion works because it´s not really a sum.

I think the idea is to calculate for each month the cumulative total amount of projects with (Yes) divided by the cumulative total amount of projects (Yes+No).

Any suggestions?

Thanks!

Solved! Go to Solution.

Accepted Solutions

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-24-2017 08:23 PM

All Replies

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-23-2017 07:00 PM

Hi @karimk,

Based on my understanding, you create a line chart, the month is set on Axis, the y-axis shows how many projects were finished on time (%). If it is, please creat a table including month column, try to create a measure using the following formula and check if it works fine.

cumulative total11 = VAR current = MAX ( 'Month'[Month] ) RETURN DIVIDE ( CALCULATE ( COUNT ( baseLIC[On time?] ), FILTER ( baseLIC, baseLIC[Month] <= mm && baseLIC[On time?] = "Yes" ) ), CALCULATE ( COUNT ( baseLIC[On time?] ), FILTER ( baseLIC, baseLIC[Month] <= mm ) ) )

For your measure posted, I don't know why do you use ALLSELECTED? There is a slicer in your report? We assume create a measure named("Onetime") to calculate how many projects were finished on time (%), we should get "Onetime" for Jan, "Onetime" of Jan+Feb on Feb month, "Onetime" of Jan+Feb+Mar on Mar month and so on.

In addition, you'd better share some sample data, you can create dummy data and expected result for better analyzing. So that we can reproduce your scenario.

Thanks,

Angelia

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-23-2017 07:44 PM

Hi,

Share some data and show the expected result.

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-24-2017 09:14 AM

Hey guys. Thanks. I have a simple dataset in the link below.

https://www.dropbox.com/s/as25atr7ls4vq20/Sample%20Data.xlsm?dl=0

Cheers.

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-24-2017 08:23 PM

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-27-2017 08:28 AM

Hi Ashish,

The link isn´t working.

Can you try again?

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-27-2017 02:49 PM

Hi,

The link is working just fine. Please retry.

## Re: Cumulative Values By Month

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-28-2017 06:40 PM

Hi @karimk,

If the solution is acceptable, please mark the useful/helpful reply as answer, and welcome to share your own solution. More members will get workaround easily and clearly.

Thanks,

Angelia