Help with some DAX

[Anonymous]

I have this measure that is working properly, but now management wants this value (percentage) shown either on a line graph or bar chart for trending and forecast purposes.

This is the measure that gets me a numerator(then I get the total for that day for the denominator): SDNDR = CALCULATE(COUNTROWS(qryGetMEWO),qryGetMEWO[DaysToResponse]>=0,qryGetMEWO[DaysToResponse]<2) and then from those two figures I get a measured percentage.

How do I translate that formula into a daily figure?  So if my manager wants to see the past 30 days, 3 months, year, etc, he can use the slicer to do so?  I have been trying to wrap my head around this an I am not quite there yet.  Right now I am creating a new table with dates and it is getting the current daily counts and I was going to do a column for the SDNDR count then divide the two to get a daily percentage I can trend against.

Thanks for the help and information

[Chihiro · Accepted solution]

I don't think you need to change anything for the measure, assuming that you have Datetime/Date column in the table.

Create Date Dimension table using either DAX calendar function(s) or using "M" in query editor.

Relate the date columns, making sure Dimension is used as primary.

Plot chart using Dimension date column as axis. Use your calculated measure as value.

Then add either timeline slicer or regular slicer as control.