topic Create A Count Card Dasboard For Each Status in DAX Commands and Tips

Create A Count Card Dasboard For Each Status

Anonymous — Fri, 13 May 2022 09:59:06 GMT

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

Re: Create A Count Card Dasboard For Each Status

Anonymous — Fri, 13 May 2022 10:50:52 GMT

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.

Re: Create A Count Card Dasboard For Each Status

Anonymous — Fri, 13 May 2022 11:01:52 GMT

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