Forum Discussion
eddd83
7 years agoResolver I
dax studio - filter function
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?
I believe this will have your answer:
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
1 Reply
- LivioLanzoSolution Sage
I believe this will have your answer:
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/