Forum Discussion
DAX Count, Summarize, Groupby, Filter
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.!
3 Replies
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,
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.
