cancel
Showing results for
Did you mean:
Regular Visitor

## 2 FILTERS

Hi All,

Its possible to insert 2 filters in one DAX formula ?

Im filtering this table with all that have '2' on column (Calculo Eval No Cumplidas) but I still need to insert one more filter on another column (FINAL TIEMPO) <= TODAY()

1 ACCEPTED SOLUTION
Community Support

Hi @k1ko92

If you put two filters in Filter() , you will get an error : “The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.” In that case, we could wrap our code in an aggregation function . You can create a measure like this :

``Measure = CALCULATE(SELECTEDVALUE('Table'[ID]), FILTER('Table','Table'[Calculo Eval No Cumplidas]=2 && 'Table'[FINAL TIEMPO]<=TODAY()))``

Then put the measure in your data table .

Original data table :

The table with measure :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi @k1ko92

If you put two filters in Filter() , you will get an error : “The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.” In that case, we could wrap our code in an aggregation function . You can create a measure like this :

``Measure = CALCULATE(SELECTEDVALUE('Table'[ID]), FILTER('Table','Table'[Calculo Eval No Cumplidas]=2 && 'Table'[FINAL TIEMPO]<=TODAY()))``

Then put the measure in your data table .

Original data table :

The table with measure :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@k1ko92
Yes. You just need to add && like:
Table[Calculo Eval No Cumplidas] = 1 && Table[FINAL TIEMPO] <= TODAY()