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.
Using DAX studio, I'm trying to understand what data this filter function is pulling.
EVALUATE FILTER ( 'TM Freight Charges', 'TM Freight Charges'[Related Order Type] = Fact_Table[Order Type])
However, I get the following error message:
"A single value for column 'Order Type' in table "Fact_Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
Evaluate FILTER ('TM Freight Charges', AND ( AND ( AND ( 'TM Freight Charges'[Related Order Type] = [Order Type], 'TM Freight Charges'[Related Order Number] = [Order Number] ), 'TM Freight Charges'[Volume] = Fact_Table[Volume] ), 'TM Freight Charges'[Charge Type] = "BASE" ) ) )
If this was a SQL problem, I would just do an INNER JOIN along with some WHERE statements, but in DAX Studio, I don't have a clue. Help?
Solved! Go to Solution.
I believe this will have your answer:
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
I believe this will have your answer:
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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 |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |