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

Ritaf1983's avatar
Ritaf1983
Super User
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
    Super 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