Can two calculated measure further calculated ?

[goyalsa]

I am trying to create a calculated measure :

Table 1 -  Get forecasted demand (which is calculated by "calculate measure")

Table 2 - Get Numbers by appying calculated measure

Now, I am trying to to fugure out, how to make a calculated measure or formula which provide me final number based on(Available - Forecasted demand) week-wise.

Thanks in advance !!

[goyalsa]

Hi @amitchandak ,

As per your solution, I managed to get the last week calculation for next week, but I am stuck to find out how to continue while taking last week number and subtract from forecast and continue for further weeks.

Really need guidance. Thanks in Advance !!

[v-yiruan-msft]

Hi @goyalsa ,

Could you please provide some sample data(exclude sensitive data) and expected result with examples and backend logic? Is the below table is what you want? If yes, you can refer the solution in the following thread.

Country	LoadingWeek	_Available	_Forecast	_Final
Singapore	202116	98	57	41
Singapore	202117	41	20	21
Singapore	202118	21	16	5

Inventory calculation using DAX

Best Regards

[goyalsa]

Hi, Seems like the measurement is working fine. But Stuck on one point.

In the above Screen shot, I want to take _Available for LoadingWeek 202117 as _Final came out in LoadingWeek 202116.

@amitchandak 

Thanks in advance!!

[amitchandak · Accepted solution]

@goyalsa , You can use a measure inside a measure

so you can create

measure 3 =[Available] - [Forecasted demand]

As they are from the different tables, they should be displayed against common dimension or as grand totals

[goyalsa]

@amitchandak 

Initially, I tried the same way but did not work.