Question regarding if function

[hidenseek9]

Power BI Community,

I have a sample data such as below.

When a column "Sequence" is "Actual", I have actual data in rebate column.

When a column "Sequence" is "Forecast", I do not have rebate data.

What I would like to do is to create a measure with if function and calculate function combinations to calculate rebate when "Sequence" is "Forecast"

For instance, I would like to calculate rebate as

• if "Sequence" is "Actual", then I want a sum of rebate in the dataset.
• if "Sequence" is "Forecast", then I want a product of Gross Sales and what-if parameter measure (in this case, -25)

However, when I try if DAX it only recognizes a measure not a column value such as "Actual" or "Forecast"

Please find below as the sample data

Sample Data

Thank you for your support!

H

[Greg_Deckler · Accepted solution]

If you are writing a measure, regardless of whether you are using an IF statement, you have to wrap any column reference in an aggregator like SUM, COUNT, MAX, MIN, etc. And, you generally need to include the table name like 'Table'[Column]. So, something like SUM('Table'[Column]).