Hi Pedro,
AVERAGEX in combination with VALUES should help you out!
Suppose you have 5 countries where you sell products and you want to show average sales across those countries over time:
1/1/2021 100$
1/2/2021 58$
etc…
Then the measure would be: Average sales per country = AVERAGEX(
VALUES(Country[ID],
[Sales])
( Here Sales is a simple measure with the sum of all sales)
Basically this table loops over each row in the datum output and calculates the average sales over all countries.