Create a group of filters to reuse in subsequest measures.

[robertpayne21]

Hi All,

I'm working on a dashboard and I'm creating some measures.  For example

Sales

COGS

Profit

Net Profit

GP

I would like to display both sold and pending on a single matrix.

The question is, can I avoid passing through filter conditions that are the same.  The four filters would need to be applied to each calculate statement.  Is there a more optimal method of stating the filter group once and referencing it throughout the model.  

i.e.

GP = CALCULATE(sum(Sample[GP]),

Sample[NUMBER]=340,

Sample[Customer]<>0,

Sample[Store_Number]<>70,

Sample[CATEGORY] = "Sold")

GP = CALCULATE(sum(Sample[Sales]),

Sample[NUMBER]=340,

Sample[Customer]<>0,

Sample[Store_Number]<>70,

Sample[CATEGORY] = "Sold")

[Syk]

You could create a calculated column to fit all those requirements and reference it. Should at least make it more readable so your measures would be like

GP = CALCULATE(sum(Sample[Sales]),

Sample[include_me]="Yes")