Dynamic measure calculation based on filter selection

[SDK0415]

I would like to create a measure to have different calculations for different machines based on filter criteria, refer the screenshot from excel below. 

When I Select Machine b in Filter 1 & Mar Month in Filter 2 - the calculation should be 20(output)*23(No of working days in Mar month) = 460

When I Select Machine c in Filter 1 & Apr Month in Filter 2 - the calculation should be 30(output)*22(No of working days in Mar month)*120(Vol factor) = 75600

Coluymn A,B,C is the Data table

Column H&I is calendar table(I have a measure to calculate the no. of working days)

How can i achive it ?

[V-lianl-msft · Accepted solution]

Hi @SDK0415 ,

Try to create a measure like below:

Measure = 
var select_month = MAX('Date'[work_days])
var select_machine = MAX('Table'[Output])
var vol_ = IF(ISBLANK(MAX('Table'[Vol Factors])),1,MAX('Table'[Vol Factors]))
return select_month*select_machine*vol_

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Read about Calculation Groups and then decide if that's something you can implement with them.