cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Use measure within another measure

I have the following measures and I need a new measure called Net that is CurrentYear - PriorYear. Can I create this measure without repeating the formulas of the prior two...something like [CurrentYear] - [PriorYear] or something? All three of these will be used in a matrix with values over 12 months. Thanks.

 

CurrentYear = Format(
CALCULATE(sum(Sheet1[FinancialAmount]), filter(Sheet1, Sheet1[FinancialType]= "Current")),
"$#,##0;($#,##0)"
)

 

PriorYear = Format(
CALCULATE(sum(Sheet1[FinancialAmount]), filter(Sheet1, Sheet1[FinancialType]= "Prior")),
"$#,##0;($#,##0)"
)

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver I
Resolver I

Re: Use measure within another measure

Hi @admiralman,

 

Try to do VARIABLES within measures like below:

 

% YoY Sales = 

VAR CURRENT_SALES = SUM(SALES)

VAR PRIOR_SALES = CALCULATE(SUM(SALES);SAMEPERIODLASTYEAR(DATES))

Return

DIVIDE ( CURRENT_SALES - PRIOR_SALES; PRIOR_SALES)

 

Best regards,

View solution in original post

3 REPLIES 3
Highlighted
Continued Contributor
Continued Contributor

Re: Use measure within another measure

Hi @admiralman,

 

Once you have created measures you can use them inside others measures. Also you can change the context of them.

 

Thanks,

 

Ricardo

Highlighted
Helper III
Helper III

Re: Use measure within another measure

Thanks...I came in today and looked at my question. I think I was trying to do something a little more complicated and didnt address the question correctly. I know you can do that with measures...must have had a brain f@rt. Thanks.

Resolver I
Resolver I

Re: Use measure within another measure

Hi @admiralman,

 

Try to do VARIABLES within measures like below:

 

% YoY Sales = 

VAR CURRENT_SALES = SUM(SALES)

VAR PRIOR_SALES = CALCULATE(SUM(SALES);SAMEPERIODLASTYEAR(DATES))

Return

DIVIDE ( CURRENT_SALES - PRIOR_SALES; PRIOR_SALES)

 

Best regards,

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors