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