Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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/
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/
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |