How to reproduce the same value of Average of Rows option using expression

[Anonymous]

I have a straight table with a sum formula as follows:

sum (distinct Table.Value)

Dimensions:

Table.ID and Table.Day

Using the ID and Day dimensions, and select the average of rows option I can get the average value i need. My question if I can get the same value of average of rows of this chart, using only an expression?

Regards.

[Anonymous · Accepted solution]

Well, i think i can get this value

=avg(Aggr(sum( distinct Table.Value),Table.Day))