Forum Discussion
Count Chart
Hello,
I hope you can help.
I work in a programme that has four projects that use the same action log.
Project A
Project B
Project C
Project D
I want to create a chart focusing on one project. The Project A has serveral Workstreams.
Workstream A
Workstream B
Workstream C
Workstream D
Workstream E
I'm helping out with the action log tracking. An action can have the Status of either open or closed.
I want to count how many Actions are Open per each Workstream within Project A.
Thank you,
Luke
Hi lukasrobbo97 ,
Please have a try.
Create a measure.
measure = CALCULATE ( COUNT ( table[action] ), FILTER ( ALL ( table ), table[project] = "Project A" && table[status] = "Open" &&Table[Workstream]=selectedvalue(Table[Workstream]) ))If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
lukasrobbo97 , Logic of open is not clear.
If is based in start or end date refer
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.Hi lukasrobbo97 ,
Please have a try.
Create a measure.
measure = CALCULATE ( COUNT ( table[action] ), FILTER ( ALL ( table ), table[project] = "Project A" && table[status] = "Open" &&Table[Workstream]=selectedvalue(Table[Workstream]) ))If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
