2 FILTERS

[k1ko92]

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

[Anonymous · Accepted solution]

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.

[tamerj1]

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