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
Anonymous - the data above was the sample data in excel form. Is there a DAX colution to use in power bi?