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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
jrieman
Frequent Visitor

DAX measure to count occurrences of text results from another measure

Hello, 

 

I have a calendar table with a column, 'date', of simple dates .  I dropped 'date' into a slicer and then added a measure to a secondary table based off the user selected calendar table 'date'.

 

Measure as follows:  As Of Date = CALCULATE(MAX('Calendar Table'[Date]),ALLSELECTED('Calendar Table'[Date]))

 

Then I use this user selected date in another measure, a date diff calculation, to determine the # of days until an event occurs.  Finally, I have a last measure which lables the dynamic date calculation as either "fewer than 30 days" or "more than 30 days".  This works great when I drop the measure into a table as I can see for each record, or property, whether an event will occur in fewer than 30 days or more than 30 days.

 

QUESTION:  Users want to see the results aggregated in a donut chart.  Example, 26 properties labeled "fewer than 30 days" and 82 properties labeled "more than 30 days".  How can I make that happen and have the result dynamically driven by the date a user selects?

 

Thanks in advance!

......just learning DAX here, please be gentle : ) 

1 ACCEPTED SOLUTION
Nathaniel_C
Community Champion
Community Champion

Hi @jrieman ,

You may have to put your measure into a calculated column to allow there to be a record of how many instances of the two conditions.  Or you may be able to create a measure using VAR and create a virtual table which will allow you to do the same thing.  You would probably need to create two measures, one that returns the more and the other the less. This is pretty general, but working with what you gave us.

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Nathaniel_C
Community Champion
Community Champion

Hi @jrieman ,

You may have to put your measure into a calculated column to allow there to be a record of how many instances of the two conditions.  Or you may be able to create a measure using VAR and create a virtual table which will allow you to do the same thing.  You would probably need to create two measures, one that returns the more and the other the less. This is pretty general, but working with what you gave us.

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.