Create A Count Card Dasboard For Each Status

[Anonymous]

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

[SanketBhagwat · Accepted solution]

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.

[Anonymous]

Thank you! but how to format the campaign based on the staus value?