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 Mon...
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.

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.