How to create a calculated column based on filter selected

[Anonymous]

I am trying to create a calculated column based on filter selected

This is my base table:

year	month	value	location
2020	(01) JAN	2	A
2020	(02) FEB	1	B
2020	(03) MAR	5	C
2020	(04) APR	5	A
2020	(05) MAY	3	A
2020	(06) JUN	5	C
2020	(07) JUL	3	B

I would like to create a matrix that likes this: create a calculated column "newest location" always show the location of the max month selected. i need this as a column not a measure buecasue i need to put this in a Matrix as 'Rows"

When month 1 & 2 is selected:

	newest location	(01) JAN	(02) FEB
value	B	2	1

When month 1 & 2 &3 is selected:

	newest location	(01) JAN	(02) FEB	(03) MAR
value	C	2	1	5

[amitchandak]

@Anonymous , You can not create a calculated column based on the slicer. The column is calculated and stored as physical data and static in nature.

You have think about that calculation like Measure

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

You can measure like SUMX , COuntX etc , Here you can have column calculation

example

new column = [Price]* [Qty]

 Sales measure = Sum([new column]

You can have measure like

New Sales  - Sumx(Table, [Price]* [Qty] )

[AllisonKennedy · Accepted solution]

Calculated columns never change based on slicer and filter selections, so it must be created as a Measure unfortunately. If you need it on rows, you may need to get creative with how you display the values in the matrix. There is an option to show values on rows, but that affects all values. You could display two tables/matrices side by side. You could also go the really tedious route of creating a measure for each month, so that newest location and all the monthly aggregates can be placed in Values in the matrix.