Query in calculated Measure

[jitendraadh]

Can Some one help me to get correct total in calculated measure in given below table?
			Mkt Value	Mkt Value
Mutual Fund	Units	NAV	By Calculated Column	By Calculated Measure
MF1	100	1.1	110	110
MF2	200	2.2	440	440
MF3	300	3.3	990	990
Total	600	Not applicable	1540	3960
			correct value	incorrect value
			It is arrived by summation of values in calculated column	It is arrived by multiplication of total units i.e.600 and total of NAV i.e. 6.6 which is illogical
formula used in calculated measure = units*sum(NAV)
Note :- if I doesn’t insert "Sum" function then it doesn’t allow me to select "NAV" column

[MattAllington · Accepted solution]

You need SUMX. something like this

=SUMX(values(tablename[mutual fund]),tablename[units] * tablename[NAV])

Read my article here https://exceleratorbi.com.au/use-sum-vs-sumx/

[jitendraadh]

Thank you