Forum Discussion
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()
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
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.
