Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Column and measure without selectedvalue

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 ?
Need Help

2 Replies

  • sturlaws's avatar
    sturlaws
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    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.