Calculate average commercial income (amount) per month in a dynamic way

[Syndicate_Admin]

Nice day
Friends request your support for the following: I need to calculate the average of commercial income (amount) per month in a dynamic way, that is, that when selecting the table or graph of bars or ring graph or applied column graph, Show me that total on a card of what he selected. I placed on the card the total of commercial income as a field and I put the option of average and it takes it out badly, that is, if I select 12 months for all accounts, it should be the total of my income divided 12 months, but with the average that is found as an option in the card / fields / average, it adds the number of months for accounts that I have there, that is, a sum of 12 months ago for 11 accounts that I have, which is equal to 132 months and is wrong

This is my table:

The number of Accounts that exist is 11, each one has its income per month.

This is my card:

There you see the total of commercial income that between 12 months should be: 27,102.21 and not the amount shown there of 2,463.84 that is calculated for 132 months that is of each account that is wrong.

I have tried several formulas, but I cannot find the solution:

DIVIDE( SUM('RentaMercantiles'[Commercial Income]) ,DISTINCT(VALUES('RentaMercantiles'[Date].[ Mesno])), 0 )
DIVIDE(SUM('Commercial Revenues'), (DISTINCT(ALL SELECTED) ('Commercial Revenues'[Date].[ Mesno]))),0 )
AVERAGEX(DISTINCT('Commercial Revenues'[Date].[ Month]),SUM('Commercial Revenues'[Commercial Income]))
AVERAGEX(SUM('Commercial Revenues'), DISTINCT('Commercial Income' [Date].[ Month]))

var Descrip = CONCATENATEX(DISTINCT(ALLSELECTED('IngresosMercantiles'[Date].[ Month])),'Commercial Revenue'[Date]. [Month],",")
RETURN
CALCULATE(
AVERAGE(Describe,
'Commercial Revenue' [Date] . [Month] IN {
"January",
"February",
"March",
"April",
"May",
"June",
"July",
"August",
"September",
"October",
"November",
"December"
}
)

I thank you for any support in this case.

Waiting for a prompt response.

[Syndicate_Admin · Accepted solution]

Nice day

I think I have achieved the solution to my problem, and that is:

Average Ing_Merc = AVERAGEX(

KEEPFILTERS(VALUES('Merchant Revenue' [Date].[Monthno])),

CALCULATE(SUM('Commercial Revenues' [Commercial Income])))

greetings my friends...