Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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()
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |