Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
xierwee
Helper I
Helper I

using result from another measure

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

datefundnorm_return
3/31/2010systematica0.00002
3/31/2010winton0.0155
2/28/2010systematica0.0005
2/28/2010winton-0.0045
1/31/2010systematica-0.011502
1/31/2010winton0.0374
12/31/2009systematica0.016721
12/31/2009winton0
11/30/2009systematica-0.029598
11/30/2009winton0.004
10/31/2009systematica-0.0650995
10/31/2009winton-0.004
1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

You can call a measure within another measure... 


Connect on LinkedIn

View solution in original post

5 REPLIES 5
tex628
Community Champion
Community Champion

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

Try this ! 🙂


Connect on LinkedIn

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


@tex628 wrote:
Measure = Calculate(norm_return; Allexcept(calendar[Date])

Try this ! 🙂


 

tex628
Community Champion
Community Champion

You can call a measure within another measure... 


Connect on LinkedIn
adityavighne
Continued Contributor
Continued Contributor

Use Matrix instead of table ..

 

Capture.PNG

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.