Refactor filter

[rtremochajr]

Hi,

 

I have a multiple measure that almost identical. How can I refactor this measure? See sample below for your reference

Email =

CALCULATE(

COUNT('Report'[RequestID]),

'Report'[Request Mode] == "E-mail",

'Report'[Request Status] == "closed",

'Report'[Overdue Status] == "false",

'Report'[Completed Time].[MonthNo] == MONTH(MAX('Report'[Completed Time])),

'Report'[Completed Time].[Year] == YEAR(MAX('Report'[Completed Time]))

)

Web Form=

CALCULATE(

COUNT('Report'[RequestID]),

'Report'[Request Mode] == "Web Form",

'Report'[Request Status] == "closed",

'Report'[Overdue Status] == "false",

'Report'[Completed Time].[MonthNo] == MONTH(MAX('Report'[Completed Time])),

'Report'[Completed Time].[Year] == YEAR(MAX('Report'[Completed Time]))

)

[ValtteriN]

Hi,

I recommend using tabular editor and C# scripts. Here are some useful examples from their documentation:
Useful script snippets | Tabular Editor Documentation



I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/