Forum Discussion

SDK0415's avatar
SDK0415
Frequent Visitor
4 years ago
Solved

Dynamic measure calculation based on filter selection

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 ?

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    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.