Use a measure in other measure

[Kemir]

Hello,

I need to make a measure, the difference of the revenue with the largest year in the filter less the previous year and I have 6 different years.

I have this:

Max year(measure) = Calculate the largest year of the column

Max year-1(measure) = Calculate the previous year of the largest.

And this is the new measure that I am trying to do:

Var Years = (CALCULATE(SUM(BD[Revenue]),BD[Year Report]=[MAX YEAR])) - (CALCULATE(SUM(BD[Revenue]),BD[Year Report]=[MAX YEAR-1]))

Thanks!

[v-shex-msft]

Hi @Kemir,

I think you can take a look at below link which about the compare between two years:

Comparing this year and last year measure on a bar chart

Regards,

Xiaoxin sheng

[GilbertQ]

Hi there, what is the error you are getting or what are you not being able to see?

If you have any screenshots to show, would be ideal.

[Kemir]

Hi,

The calculate would be for the 5 different years.

 

[KHorseman · Accepted solution]

You are using measures as filter criteria. I believe that has to be nested inside an explicit FILTER() statement.

Your Measure = CALCULATE([Whatever], [Measure] = "x")

Correct Measure = CALCULATE([Whatever], FILTER(TableName, [Measure] = "x"))

[Kemir]

It does not work yet.

This is my measure:

My Measure: = (CALCULATE(SUM(BD[Revenue]),BD[Year Report]=MAX(BD[Year Report])) - CALCULATE(SUM(BD[Revenue]),BD[Year Report]=(MAX(BD[Year Report])-1)) )

I need that the criteria would be the largest number in the column.

[Kemir]

Thanks!

All right!!!

[KHorseman]

Well it won't work if you don't actually do what I said...