Need help in calculating the average row wise value in dax

[Anonymous]

i need to calculate the average value row wise in dax. in the below result if i select 2 dates the result should be (6+1092)/2= 549, simillarly for other dates. Note: the value was wriiten in measure

Date	value
01-11-2023	6
02-11-2023	1092
03-11-2023	5
04-11-2023	8
Result
6
549
367.6
277.7

[Ahmedx]

and it’s not clear what and how you want to visualize, I made it on a map and it’s not suitable for tables and or matrixes

[Anonymous]

Thank you so much for your reply, Let me make this more clear,
I have date column , and unique customer column , In the Unique Customer column i have used Measure to get unique customers every month.

This is the formula i have used to get unique customers, after getting unique customers every month, i have to calculate the average.

Date	Unique Customers
01-11-2023	6
02-11-2023	1092
03-11-2023	5
04-11-2023	8
Result
6
549
367.6
277.7

If the use the formula that you have shared i got result 1 in Card visual, i have hecked other visual still the same.

[Ahmedx]

pls try this

[Anonymous]

i am getting result as 1 for all the dates

[Ahmedx]

I don't know what they wrote there, show me the file