Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 Canc...
DAX
DAX Commands and Tips
Help me
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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.