DAX measure to count occurrences of text results from another measure

[jrieman]

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

[Nathaniel_C · Accepted solution]

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