Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

traffic light summary

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...
Need Help
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi Anonymous 
    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 
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