topic Re: 2 FILTERS in DAX Commands and Tips

2 FILTERS

k1ko92 — Fri, 06 May 2022 12:43:10 GMT

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

Re: 2 FILTERS

tamerj1 — Fri, 06 May 2022 12:48:57 GMT

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

Re: 2 FILTERS

Anonymous — Tue, 10 May 2022 06:54:47 GMT

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.