Count Chart

[lukasrobbo97]

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

[Anonymous · Accepted solution]

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.

[amitchandak]

@lukasrobbo97 , Logic of open is not clear.

If is based in start or end date refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.