DAX Count, Summarize, Groupby, Filter

[colourfullife]

Hi,

I have got a query in power bi and the table what I'm trying to group or summarize then count has various coloums.

I want to show a cummulative % graph of Start, Finish Plan VS Start, Finish Actual by discipline.

Discipline / Plan Start Date/ Actual Start Date/ Plan Finish Date/ Actual Finish Date  

Piping/        04/12/2018/       01/02/2019/         04/01/2019/          08/02/2019

Piping/        06/12/2018/       01/02/2019/         04/01/2019/          08/02/2019

Piping/        05/12/2018/       01/02/2019/         04/01/2019/          08/02/2019

Piping/        07/12/2018/       01/02/2019/         04/01/2019/

Structure/    04/01/2019/                                   05/02/2019/

Structure/    04/01/2019/                                   05/02/2019/

Structure/    03/01/2019/                                   05/02/2019/

Structure/    04/01/2019/       08/02/2019/        05/02/2019/

Machanical/ 04/01/2019/                                  06/02/2019/

Machanical/ 05/04/2019/                                  06/02/2019/

Machanical/ 05/07/2019/       08/02/2019/       06/02/2019/

What I need to group or summarize then count is look so:

- Calendar: have earliest to latest dates above talbe has 

- for cumulative need to count blank as 0

- Total Number of Piping

Piping Table

Calendar/      Plan Start Date/ Actual Start Date/ Plan Finish Date/ Actual Finish Date / Plan Start Cul/ Total number

01/12/2018             1                         1                          1                              1                          1                      80

02/12/2018             2                         2                          1                              2                          3                      80

03/12/2018             4                         2                          1                              3                          7                      80

04/12/2018             1                                                                                                                 8                      80

        .                                                                                                                                          .                       80

        .                                                                                                                                          .                       80

        .                                                                                                                                          .                       80

05/02/2019                                                                    1                                                          8                      80

06/02/2019                                        1                          2                                                          8                      80

07/02/2019             1                         1                          2                                                          9                      80

08/02/2019                                                                                                                                9                      80

The goal is to take counted table by discipline to create cumulative graph that have 4 lines (Start plan date, Start actual date, Finish plan date and Finish actual date).  

Thanks in advanced for any help.

The goal from;

I've made a graph like so;

the problem is when i filter dicipline Piping ,for example, in the slicer.

It doesn't show from 0% to 100%.  so trying to make each dicipline tables.!

 

[v-chuncz-msft]

@colourfullife,

You may research the code generated by Quick measure Running total.

[colourfullife]

Hi, thanks for your reply.

I've been trying to play around the quick measure..

It doesn't get me what i want.

i attached the file i working with. can you show me how it works?

thank you,

[colourfullife]

Here is the native file attached.

There is a cumulative graph have 4 lines (Start plan/ Start Actual/ Finish plan/ Finish Actual) with slicers.

what makes me head bang is when i choose any options in slicer. want to see 0%-100% lines graph.?

1. Do i need to measure every single slicer's options?

2. what if i want to choose more than 2 options from slicer?

Many thanks for any help.