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
    )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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
    )
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi Tamerj1,

thanks for your swift response but this solution did not work as well. Had to solve it in a different way by adding the calculations in the DSA. By doing so, i was able to deliver the proper info.

Again, appreciate your support!!!

thnnx!!

Maarten