IF Formula based on Text value

[Aaron1]

HI,

I am new to Power BI and cant figure out how to get my IF statement to work.

I have 2 tables:

1. Basket Location Brand Data

2. RIR Data

Within the Basket table i have a column called [Channel] which has 4 attributes - Large, Small, Online & X. The Basket table contains all my sales information and is attributed by channel

I would like to write a measure that uses 1 of 4 different measures from the RIR table based on the channel attribute that is selected in the page level filter - the measures in the RIR table are Out Performance (Large), Out Performance (Small), Out Performance (Online) & Out Performance (Total)

the outcome i am trying to achieve is to show a marketoutperformance figure that matches the channel and sales data that is selected from the page filter without building 4 seperate pages.

Thanks and apologies if this is a very basic question

Aaron

[v-yuezhe-msft]

@Aaron1,

Do you have any relationship between the above two tables? Could you please share dummy data of the two tables and post expected result based on dummy data here?

Regards,
Lydia