Get the Category Label in other column based on differente criteria

[didakk]

Hi Everyone!

Im very newbi in pbi and I  have the following visualization 

How do I put the Category text label where for example Year = 2021 and Rank = 2 in all rows of the desired column?

The expected output must be:

Year	Rank	Channel - MMM Optimizer	301_Vol_Value	Desired Channel Measure
2019	2	Social Media	2.30%	Display
2020	2	Social Media	3.10%	Display
2021	2	Display	1.90%	Display
2022	2	Social Media	1.60%	Display

In 2022 for example, should be Social Media in all rows

So far I've done this with no success

Desired Channel Measure =     

CALCULATE(MAX(Data[Channel - MMM Optimizer]),FILTER(Data, Data[Rank] = SELECTEDVALUE(Data[Rank]) && Data[Year] = SELECTEDVALUE('Calendar'[Year]))

)

Thanks in advance!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try something like below.

Desired Channel Measure =
VAR _rankselect =
    SELECTEDVALUE ( Data[Rank] )
VAR _yearselect =
    SELECTEDVALUE ( 'Calendar'[Year] )
RETURN
    MAXX (
        FILTER ( ALL ( Data ), Data[Rank] = _rankselect && Data[Year] = _yearselect ),
        Data[Channel - MMM Optimizer]
    )