Column and measure without selectedvalue

[Anonymous]

I've a slicer datemonth 

measure: Measure 2 = MAXX(ALLSELECTED('YTD Calendar'[Period Name]),'YTD Calendar'[Period Name])

Column: Column = MAXX(ALLSELECTED('YTD Calendar'[Period Name]),'YTD Calendar'[Period Name])

I'd like to get column the same result as measure2 without using selectedvalue please? I need to get the result in a column and not in a measure

How should correct column to get the correct values ?

[sturlaws]

Hi, @Anonymous,

if by Column you mean a calculated column in your model, this is not possible, calculated columns cannot be made to respond to slicer selections.

Depending on what you are trying to do, there a couple of things that might help you:
- create a temporary column using addcolumn

- field parameters

But I would need to know why you need to have that value in a column in order to help further.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[Anonymous]

@sturlaws The main issue is expalined here https://community.powerbi.com/t5/Desktop/dynamically-change-the-name-of-a-label-in-a-column/m-p/2970...

Both questions are related and I'm looking for a soltion since few weeks.. Any help will be too much appreciated 🙂