Forum Discussion
Refactor filter
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]))
)
1 Reply
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/
