Forum Discussion
average based on date slicer
hi dears
i need to get the average of transactins based on date slicer
currently i inserted a visual card which will show me the count of transactions per date slicer and it works fine
but i dont know what should i do to get the average of ( counted transactions per date slicer )
Hi Anonymous ,
I have tested sudhisami_azure 's solution and there is no error, here is the test results:Total = COUNT('Table'[Count])Average = AVERAGEX(VALUES('Table'[Date]), [Total])60 / 28 =2.14285......
Or you can try:Average 2 = VAR _Date = DISTINCTCOUNT('Table'[Date]) RETURN [Total] / _Date
If you still can't implement it, then there is a problem with your data structure and not with DAX, as ryan_mayu said, please provide sample data or a pbix file.
Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.
7 Replies
Hi Anonymous ,
I have tested sudhisami_azure 's solution and there is no error, here is the test results:Total = COUNT('Table'[Count])Average = AVERAGEX(VALUES('Table'[Date]), [Total])60 / 28 =2.14285......
Or you can try:Average 2 = VAR _Date = DISTINCTCOUNT('Table'[Date]) RETURN [Total] / _Date
If you still can't implement it, then there is a problem with your data structure and not with DAX, as ryan_mayu said, please provide sample data or a pbix file.
Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.thank you for your help
i just checked the file and it does not work( my file contain a query which i get it form my sharepoint website)
but when i created a new report ( improt from excel ) it work excalty like what you attached
so just for my knowledge what you think the issue is from ? unfortuntly i cant attached the file here because it contains some sensitive informatiomn related to my duty
Anonymous
maybe you can try this
avearge= total transactions / datediff((min(submitted date),max(submitted date),day)
Hi,
If you have Sales, Date tables, you can try like this:
CountOfSales = COUNT(Sales[SalesID])
AverageSalesTransactions = AVERAGEX(VALUES(Date[Date]), [CountOfSales])could you pls provide some sample data or pbix file?
