Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jeyeline
Helper I
Helper I

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

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?

 

 

1 ACCEPTED SOLUTION
talespin
Solution Sage
Solution Sage

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")

View solution in original post

1 REPLY 1
talespin
Solution Sage
Solution Sage

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")

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.