If Then - Need Help

[varunv11]

Hello, 

I have a column on my model which give me the category of the product. And i have a calculated column for sales per product. I need to calculate the annualized sales per category.

In excel i use Annualised Sales = if(category = "ABC", Sales / 1.2, if(category = "XYZ", Sales / 3.5),0)

Category column is part of the model and is not a calculated value. Sales is a calculated measure created on BI. 

Please help. 

Warm Regards 

Varun Raj

[v-yulgu-msft · Accepted solution]

Hi @varunv11,

You could new a measure:

Annualised Sales =
IF (
    SELECTEDVALUE ( Table[Category] ) = "ABC",
    [Sales] / 1.2,
    IF ( SELECTEDVALUE ( Table[Category] ) = "XYZ", [Sales] / 3.5, 0 )
)

Best regards,

Yuliana Gu