Forum Discussion

BartVlek's avatar
BartVlek
Helper II
6 years ago

Problems with syntax in combination with Related

I am having problems with getting the syntax right for the following expression:   CostPrice = IF ( (RELATED ( 'discount'[percentage] ) = 0, ( 'total'[PAMP] ), ( ( 'total'[AMOUNT] ) * ( RELATED...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

BartVlek , Are these two tables joined? Are you creating a measure or a column?

Can you share sample data and sample output.

 

If it a column this should work

CostPrice =
IF (RELATED ( 'discount'[percentage] ) = 0, 'total'[PAMP] , 'total'[AMOUNT] * RELATED ( 'discount'[percentage] )
)

If measure =

CostPrice =
Sumx('total', IF (RELATED ( 'discount'[percentage] ) = 0, 'total'[PAMP] , 'total'[AMOUNT] * RELATED ( 'discount'[percentage] )
))

  • BartVlek's avatar
    BartVlek
    Helper II
    6 years ago

    Yes the tables are joined, and I am creating a column