Cumulative totals in graph

[frankhofmans]

Hi PBI experts,

i have a date table with the productname (A,B,C ...) en the number of days it took to produce the product (still in production if the number of days is empty).

Productname	# of Days
A	3
C	1
C	5
B	7
B	3
B	2
A
A	1
A
C	2

I want to create the following graph:

Day	1	2	3	4	5	6	7	8	9
% of # of products	20%	40%	60%	60%	70%	70%	80%	80%	80%

Can anyone solve this problem?

Thanks in advance,

Regards,

Frank

[V-pazhen-msft · Accepted solution]

@frankhofmans 
You need a # day column created in a new table. Check my pbix. 

% Measure = 
var running_count = CALCULATE(COUNT('Table'[# of Days]),FILTER(ALL('Table 2'),'Table 2'[# of Days]<=MAX('Table 2'[# of Days]))) 
var count_days    = CALCULATE(COUNTROWS('Table'),ALL('Table'))

Return running_count / count_days

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@frankhofmans - Sorry, how are those numbers in your graph supposed to be calculated?

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[frankhofmans]

hi Greg,

i have a measure with the number of products produced (in this case 10). I want a extra measure with the cumulated totals, so 2 products are produced on day 1, so that's 20% of the total number of products. On day 2, again 2 products are produced, so the cumulated total on day 2 is 4 produced products (40%). On the X-axis i want the day number (day of production) and on the Y-axis the number of produced products (=< day number) as % of the total number of products produced (10 products).

Thanks in advance,

Regards,

Frank