topic Create a group of filters to reuse in subsequest measures. in DAX Commands and Tips

Create a group of filters to reuse in subsequest measures.

robertpayne21 — Fri, 21 Jul 2023 18:23:28 GMT

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")

Re: Create a group of filters to reuse in subsequest measures.

Syk — Fri, 21 Jul 2023 18:34:45 GMT

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")