Forum Discussion
Anonymous
3 years agoNot applicable
MdxScript (Sales) (1890,3) Calculation error in measure.
hi, created this DAX measure in Azure Analysis Server (AAS): IF ( [WarrantyLimit1]=0, SUM([Measurement1])*'Sales'[InvoicedQty], IF( LEFT([Meter3],4) = "TRAB", SUM([Measurement3])*'Sales'[Invo...
- 3 years ago
Anonymous
Perhaps the same column name is used for another column in another table which makes it impossible for the engine to identify which is which without specifying the table name. The standard is to specify the table name along with the column name when referencing a column and not to include the table name when referencing a measure. Please tryTranspoKarton = IF ( [WarrantyLimit1] = 0, SUM ( 'Dim_Product'[Measurement1] ) * 'Sales'[InvoicedQty], IF ( LEFT ( [Meter3], 4 ) = "TRAB", SUM ( 'Dim_Product'[Measurement3] ) * 'Sales'[InvoicedQty], 0 ) )
tamerj1
Community Champion
3 years agoHi Anonymous
what are Measurement1, Measurement1 and Meter3? Are they measure or columns? If columns then in which table? What are the relationships between the tables? How does the visual look like.