Forum Discussion
Create A Count Card Dasboard For Each Status
Hello i have the follwoing table:
| Status | Campaign type |
| Completed | A |
| Completed | A |
| Completed | B |
| Completed | R |
| Completed | D |
| Completed | A |
| Cancelled | F |
| Cancelled | GS |
| Cancelled | GS |
| Cancelled | W |
| Cancelled | E |
| Cancelled | T |
| Cancelled | U |
| Cancelled | W |
| Cancelled | HG |
| Cancelled | SF |
| Cancelled | AS |
| Cancelled | YF |
| Paused | A |
| Paused | N |
| Paused | N |
| Paused | J |
| Running | L |
I want to create a dashboard of seperate cards to give me the count of each status , then i want to conditional format the campaign type to a color for each status i asign.
I appreciate the help
Hi Anonymous .
Create a measure for count as ;
CountCompleted=CALCULATE(COUNTROWS(TABLE),FILTER(Table'[Status]="Completed")
In the same way you can create count of all other status and put them inside cards.
In format pane, you will see option for conditional formatting.
Let me know if that helps.
Thanks,
Sanket
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.
2 Replies
Hi Anonymous .
Create a measure for count as ;
CountCompleted=CALCULATE(COUNTROWS(TABLE),FILTER(Table'[Status]="Completed")
In the same way you can create count of all other status and put them inside cards.
In format pane, you will see option for conditional formatting.
Let me know if that helps.
Thanks,
Sanket
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.