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.
1 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
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
Thanks, is it possible to count the count for each of the status?
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
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
