Forum Discussion

chestern's avatar
chestern
Regular Visitor
4 years ago
Solved

Calculate daily average across months

Hello,   I am attempting to calculate the average number of incidents reported per day across the months of September and October, which have 30 and 31 days respectively. I have 25 total incidents ...
Need Help
  • chestern's avatar
    chestern
    4 years ago

    I just figured it out. I created two measures:

     

    Measure = IF(COUNT(Base[Date Reported].[Date])=365, 61, COUNT(Base[Date Reported].[Date]))
    Measure 2 = COUNT(Base[Classification]) / [Measure]
Gabriel_Walkman's avatar
Gabriel_Walkman
Icon for Continued Contributor rankContinued Contributor
4 years ago

What should happen when no months are selected?

  • chestern's avatar
    chestern
    Regular Visitor
    4 years ago

    The textbox should display the average reported incidents per day as about 0.41 (25 incidents divided by 61 days), but the measure is dividing the incidents by 365 days.