Get the Category Label in other column based on differente criteria

didakk — Mon, 07 Aug 2023 19:06:14 GMT

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!

Re: Get the Category Label in other column based on differente criteria

Jihwan_Kim — Tue, 08 Aug 2023 03:18:23 GMT

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] )

topic Re: Get the Category Label in other column based on differente criteria in DAX Commands and Tips

Get the Category Label in other column based on differente criteria

Re: Get the Category Label in other column based on differente criteria