average based on date slicer

[Anonymous]

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 )

[Anonymous · Accepted solution]

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.

[Anonymous]

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

[sudhisami_azure]

Hi,

If you have Sales, Date tables, you can try like this:

CountOfSales = COUNT(Sales[SalesID])
AverageSalesTransactions = AVERAGEX(VALUES(Date[Date]), [CountOfSales])

[Anonymous]

its not working as well

what i need to do is get this value and put it into visual card

this calculation is based on total transactions 879 / 23 days ( as per submitted date slicer )

it can be done easly by using clustered column ( but i need it to be shown in card visual )

[ryan_mayu]

could you pls provide some sample data or pbix file?

[ryan_mayu]

@Anonymous 

maybe you can try this

avearge= total transactions / datediff((min(submitted date),max(submitted date),day)

[Anonymous]

it is not working brother