Forum Discussion
Need help with DAX Measure for Average Per Day
- 2 years ago
Okay, got it.
You can start by creating a general measure for your 'Good Leads' sum:Total Good Leads = SUM('Historical Data'[Good Leads])Then you can pass it into a measure that groups those sums and provides the average within the context of each unique date:
Average Good Leads Per Day = VAR distinctDates_TABLE = VALUES( Dates[Date] ) VAR result = AVERAGEX ( distinctDates_TABLE, [Total Good Leads] ) RETURN resultThe result of this value can then be used by itself, such as on a card visual, to return the total average of good leads per date, or you can use a matrix visual to further group the calculation within the context of other categories, such as inventory type, placement, month, etc.
Hi jfowings1 ,
That doesn't seem to be the underlying data, and forming that matrix seems to have to have 40 rows of data and provide the expected results you want.
Best regards,
Community Support Team_ Scott Chang
That is the sample data in excel. I still need the DAX expression or some assistance to create the average per day measurement.