using result from another measure

[xierwee]

Hi experts,

I have the following result (Table1) from a measure (

DIVIDE(sum('Performance'[weights]), CALCULATE(sum('Performance'[weights]), ALLSELECTED('Performance'[fund])))* sum(Performance[return])

). 

Now I'd like to just sum up the norm_return for each date of two funds. just tried sum or sumx, not working as expected. 

table1

date	fund	norm_return
3/31/2010	systematica	0.00002
3/31/2010	winton	0.0155
2/28/2010	systematica	0.0005
2/28/2010	winton	-0.0045
1/31/2010	systematica	-0.011502
1/31/2010	winton	0.0374
12/31/2009	systematica	0.016721
12/31/2009	winton	0
11/30/2009	systematica	-0.029598
11/30/2009	winton	0.004
10/31/2009	systematica	-0.0650995
10/31/2009	winton	-0.004

[tex628]

Measure = Calculate(norm_return; Allexcept(calendar[Date])

Try this ! 🙂

[xierwee]

not really, because norm_return is a measure, not a table or column. 

---

@tex628 wrote:

Measure = Calculate(norm_return; Allexcept(calendar[Date])

Try this ! 🙂

---

[tex628 · Accepted solution]

You can call a measure within another measure... 

[adityavighne]

Use Matrix instead of table ..

[xierwee]

hmm, I need to use the result in another measure, and then plot the result, so I'm afraid matrix wouldn't help.