weighted average

Anonymous — Tue, 21 Jul 2020 14:36:30 GMT

Hi community,
I need calculate a weighted average and i have this condition:

Weight:

Weight = SUMX('Table',
IF([category]="XPTO1" &&
MONTH('Table'[Date]) = MONTH(IF(DISTINCTCOUNT('Table'[Date])>1, NOW(),[Date])) &&
YEAR'Table'[Date]) = YEAR(IF(DISTINCTCOUNT('Table'[Date])>1, NOW(),[Date]))
,[total])
)

Value:

value= Weight = SUMX('Table',
IF([category]="XPTO2" &&
MONTH('Table'[Date]) = MONTH(IF(DISTINCTCOUNT('Table'[Date])>1, NOW(),[Date])) &&
YEAR'Table'[Date]) = YEAR(IF(DISTINCTCOUNT('Table'[Date])>1, NOW(),[Date]))
,[total])
)

Can help me?

Re: weighted average

amitchandak — Tue, 21 Jul 2020 16:12:59 GMT

Anonymous , Not very clear. Both formulae seems the same. You can make one of them as count and divide

topic Re: weighted average in DAX Commands and Tips

weighted average

Re: weighted average