Count of Closed task and open task in a card

[aqeel_shaikh]

Iam performing a card in powerbi where the status change to "Closed" then the count bar should show for closed items

similarly for open items the another card should show for "Open" items.

How can i perform this in power bi.

[aqeel_shaikh]

Thanks aton. it helped

[AnkitKukreja]

Hi! @aqeel_shaikh 

You can use the measure as suggested by Akash_varuna or you can drag and drop and then filter the data as per your status. You can use multi-row card, card(new) or a card visual to display your data. Attaching image below for the multi-row card and card(new) for your reference.

[nilendraFabric]

Create Two Measures
• Use Power BI’s COUNT + FILTER logic to tally tasks:
• One measure counts entries marked “Closed”
• Another counts entries marked “Open”

 Add Card Visuals
• Drag two Card visuals to your report canvas
• Assign the “Closed” measure to one card
• Assign the “Open” measure to the other

[Akash_Varuna · Accepted solution]

Hi @aqeel_shaikh You could achive this throug measures Could you follow these please 

Create measures:

• ClosedTasksCount:

ClosedTasksCount = 
COUNTROWS(
    FILTER(
        YourTable,
        YourTable[Status] = "Closed"
    )
)
​

• OpenTasksCount:
  

  OpenTasksCount = 
  COUNTROWS(
      FILTER(
          YourTable,
          YourTable[Status] = "Open"
      )
  )
  ​

  Add two card visuals and assign each measure to display the counts.
  If this post helped please do give a kudos and accept this as a solution 
  Thanks In Advance