DAX to count a particular column(string) across different months

[Jeyeline]

Hello Team,

  I would like to visualize data based on two columns- Broken Issue which is either Yes or No and Created date. Now I want to collect data across months for the broken issue "Yes". That is no. of work items with the broken issue for all the months.

Seeking guidance on how to create DAX for this?

[talespin · Accepted solution]

Hi @Jeyeline ,

Your date field will filter the table you feed to Calculate, it can be written in many ways and also depends on your datamodel and what fileds you have in your visual. Assuming its just date in visual, you can add this measure. Please replace table name and field name.

Measure

---------

CALCULATE( COUNT(Table[Broken Issue]), Table[Broken Issue] = "Yes")