Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
  • tamerj1's avatar
    tamerj1
    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 try

    TranspoKarton =
    IF (
        [WarrantyLimit1] = 0,
        SUM ( 'Dim_Product'[Measurement1] ) * 'Sales'[InvoicedQty],
        IF (
            LEFT ( [Meter3], 4 ) = "TRAB",
            SUM ( 'Dim_Product'[Measurement3] ) * 'Sales'[InvoicedQty],
            0
        )
    )