Forum Discussion

lekkerbek's avatar
lekkerbek
Icon for Helper IV rankHelper IV
6 years ago
Solved

Calculate measure two different tables

Hi,   Can you somebody please help me with a measure?   I have 2 tables: - Customers - Transactions   The customer table has the following relevant columns: - accountcode - accountname - c...
Need Help
  • az38's avatar
    az38
    6 years ago

    lekkerbek 

    your statement

    calculate(sum(Transacties[AmountDC]);ALL('DimRelaties');'DimRelaties'[CanDropShip]=true())

    looks pretty good to calculate total revenue by ALL customers which candropship is true

    isn't it work ok? give a data example please

    do not hesitate to give a kudo to useful posts and mark solutions as solution

lekkerbek's avatar
lekkerbek
Icon for Helper IV rankHelper IV
6 years ago

Thank you both. I will look into this in more detail as there seems to be something wrong with my model. The loopupvalue function also gives no results.

 

At least now I know the formula is correct. Thanks.