cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

## Combine TREATAS filters in FILTER function

In a CALCULATE expression I can add different filters with commas.

```TotalSells = CALCULATE( SUM(Merchandise[prices]),
Merchandise[was_sold],
TREATAS( VALUES(Calendar[date]), Merchandise[sold_date])
)```

Now I need to use the filters inside an X-function, from which the parameter changes.

```QuickSells = AVERAGEX(
FILTER(Merchandise,
[was_sold],
TREATAS( VALUES(Calendar[date]), Merchandise[sold_date])),
Merchandise[days_to_sell] <= 10
)```

This throws an error since FILTER only takes one filter.
If they were all logical, I could do mix them with & operators.
Since I have TREATAS, it gets more difficult.
Does someone know how to do this?

3 REPLIES 3
Community Support

Hi @Diego-mx,

I can't get the calculate logic from your formula, but I think it is impossible to modify teratas function to add conditions into function.

Based on my understanding, treatas function is similar as 'in' operate. Maybe you can try to use following formula if it suitable for your requirement:

```QuickSells =
AVERAGEX (
FILTER (
ALLSELECTED ( Merchandise ),
Merchandise[was_sold] = TRUE ()
&& Merchandise[sold_date] IN VALUES ( Calendar[date] )
&& Merchandise[days_to_sell] <= 10
),
Merchandise[prices]
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

The logic is that I want to find what proportion where sold in less than 10 days.
So the condition [sold_days] <= 10, gets turned into 1 and 0 and averaged.

Using ... IN VALUES(Calendar[date]) was helpful, but now the logical-to-numeric is not working.

I'll keep trying.

Community Support

HI @Diego-mx,

Can you please share some sample data with expect result to help us clarify your scenario?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors