topic Re: Dynamic measure calculation based on filter selection in Developer

Dynamic measure calculation based on filter selection

SDK0415 — Tue, 18 Jan 2022 17:25:05 GMT

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 ?

Re: Dynamic measure calculation based on filter selection

lbendlin — Thu, 20 Jan 2022 03:27:12 GMT

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

Re: Dynamic measure calculation based on filter selection

V-lianl-msft — Mon, 24 Jan 2022 07:48:07 GMT

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.