Combine different measures in one measure

[Anonymous]

Hi.
I want to find a way to get different measures with the same purpose into one measure. Many measures creates such a mess in the field overview!

I.E I want to create a measure that can show the change in Sold quantity (in %)
How I do it now:

1. Sales Quantity Measure = SUM('Valueposts'[Sales Quantity])

2. Sales Quantity LY = CALCULATE(SUM('Valueposts'[Sales Quantity]), DATEADD('Date'[Date], -1, YEAR))

3. Sales Quantity Change vs last year = [Sales Quantity Measure] - [Sales Quantity LY]

4. % change Sales Qty vs Sales Qty Last year = [Sales Quantity Change vs last year]/[Sales Quantity Measure]

Anybody know how I create these steps into one measure?
Appriciate any help!

[Tanushree_Kapse · Accepted solution]

Hi @Anonymous ,

Use the below measure:
% change Sales Qty vs Sales Qty Last year=
Var SalesQuantityMeasure = SUM('Valueposts'[Sales Quantity])

Var SalesQuantityLY = CALCULATE(SUM('Valueposts'[Sales Quantity]), DATEADD('Date'[Date], -1, YEAR))

Var SalesQuantityChangevslast year = [SalesQuantityMeasure] - [SalesQuantityLY]

Return  [SalesQuantityChangevslast year]/[SalesQuantityMeasure]

mark this as a solution if I answered your question.

Thanks