Current column value of a row

[Raul]

Dear forum,

I have this matrix visualization:

CUSTOMER	AREA	COL	Amount	LastDate(Description)
CUS1			1625,00	DESCRIPTION1
	Area1		1475,00	DESCRIPTION1
		CB	100,00
		CC	50,00
		PF	25,00
		F001	100,00	DESCRIPTION2
		F00X	1200,00	DESCRIPTION1
	Area2		150,00
		DM	150,00
Total			1625,00	DESCRIPTION1

Where LastDate(Description) it's the Description column in the values panel with a Last aggregate function. I need a measure or a column with this condition:

If COL = "F00X" then LastDate(Description) else nothing

To get this result:

CUSTOMER	AREA	COL	Amount	LastDate(Description)
CUS1			1625,00
	Area1		1475,00
		CB	100,00
		CC	50,00
		PF	25,00
		F001	100,00
		F00X	1200,00	DESCRIPTION1
	Area2		150,00
		DM	150,00
Total			1625,00

What should be the expression of the measure?

Thank you

[Raul · Accepted solution]

I have found the solution:

LastDate(Description)= IF(SELECTEDVALUE(Table1[COL])="F00X";LASTNONBLANK(Table1[COL];SELECTEDVALUE(Table1[COL])="F00X");BLANK())

[Raul]

But if I want to show only the value in the Area group, like this:

CUSTOMER	AREA	COL	Amount	LastDate(Description)
CUS1			1625,00
	Area1		1475,00	DESCRIPTION1
		CB	100,00
		CC	50,00
		PF	25,00
		F001	100,00
		F00X	1200,00
	Area2		150,00	DESCRIPTION1
		DM	150,00
Total			1625,00

How do I do it?

Thanks