traffic light summary

[epang0714]

Hi 

I have created a simple table which shows the progress of activities using conditional formatting. I would like to create a traffic light summary at the top to show number of activities which are Not started, In progress and Complete. The icons are Red, Yellow and Green. I am just stuck in creating the summary count. Currently if I click on the icon, Power BI will filter the records to the relevant status. Does any one know how can I do the summary count? the outcome I want is  eg if the user click on a particular slicer, in this case the department, then it will show how many activities are in red, yellow and green. Thanks.  

[Ritaf1983 · Accepted solution]

Hi @epang0714 
If I understood you correctly, then a simple distinct count will do the job.
You can even show the qty of every status's activities on the slicer itself:

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[epang0714]

Thanks, is it possible to count the count for each of the status?

[Ritaf1983]

Hi @epang0714 
Yes of course, but you don't need it if you are using slicers / filters/visuals with filter context .
Count of specific for specific status dax formula is :

In_progress_qty = CALCULATE(DISTINCTCOUNT('Table'[Category]), 'Table'[status]= "In progress")

the same formula for every status:
the updated pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly