Forum Discussion

murphm6's avatar
murphm6
Helper II
3 years ago

Help identify the difference between these two measures?

Hi all,

 

I have a visual in a report that counts the 'Days left in Month'. My end user wants to add functionality to look into next month, so I created a new measure which counts days between now and end the end of next month. 

 

Previous Measure = DATEDIFF(TODAY(), EOMONTH(TODAY(), 0), DAY)

New Measure = DATEDIFF(TODAY(), MAX('Calendar'[Date]), DAY)

 

New measure is working as expected

 

Here is my problem - we use this 'Days left in Month' measure to calculate % of typical demand. The formula for %Demand is 

 
%Demand = CALCULATE(AVERAGE('Indication Calcs'[% of Total Monthly Volume]), FILTER('Indication Calcs','Indication Calcs'[Value]=[Days Left in Month]))
 
When I switch out the old [Days Left in Month] for my new measure I created, I'm getting a blank value. I've confirmed there are no filters affecting the visual and have confirmed the old measure works fine. For this month, they should be returning the same values. 
 
Why is it that I'm returning a blank value? 

 

Need Help

2 Replies

    • murphm6's avatar
      murphm6
      Helper II
      3 years ago

      My max date on my calendar table is 10/1/2024, but the slicer affecting the whole page is only for the end of this month. Shouldn't this work?