Forum Discussion
Calculation other than average
Good afternoon, I hope you are well, I wanted to ask for your help, since I can not reach the result, I have the following:
nuance
Rows:
- ASSET CLASS
- BACKGROUND FUND
- series
column:
- AUM Prom Jorge
- AUM Prom Period
First calculation:
AUM Prom Jorge = AVERAGE(Consolidado[Pat. MM$])
According to calculation:
AUM Prom PerĂodo = CALCULATE(
[AUM Prom Jorge],
filter(
Consolidated
Consolidated[Calculation Date]>=DATE(2021,05,01) && Consolidated[Calculation Date]<=DATE(2021,05,31)))
therefore it gives me the following result.
what enecesito that instead of the total me of the average, me of the total of the sum of the column, it is possible, I remain attentive, thank you very much.
@Syndicate_Admin, Try measures like this measure
sumx(summarize(Consolidated, Consolidated[Asset Class],Consolidated[Fund],Consolidated[Series], "_1",AVERAGE(Consolidated[Pat. MM$])),[_1])
1 Reply
- amitchandakSuper User
@Syndicate_Admin, Try measures like this measure
sumx(summarize(Consolidated, Consolidated[Asset Class],Consolidated[Fund],Consolidated[Series], "_1",AVERAGE(Consolidated[Pat. MM$])),[_1])