Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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()
Solved! Go to 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.
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.
@k1ko92
Yes. You just need to add && like:
Table[Calculo Eval No Cumplidas] = 1 && Table[FINAL TIEMPO] <= TODAY()
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
19 | |
14 |