Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a dynamic measure column name

I created a measure that calculates the value based on a selection.  However, I need my measure title to be dynamic as well.

 
Measure = SWITCH(SELECTEDVALUE('Filter'[Column1]),"Selection 1",SUM([Selection 1]),"Selection 2",SUM(Sheet1[Selection 2]),"Selection 3",SUM(Sheet1[Selection 3]))
 
I was the name "Measure" to read whatever filter I am selected on.  Any ideas how I can do this?
 
Output Table (Example when I'm on Selection 1):
NameMeasure
Item 11
Item 21
Item 31

 

Source Table:

NameSelection 1Selection 2Selection 3
Item 1123
Item 2123
Item 3123

 

Selection Table;

Column 1
Selection 1
Selection 2
Selection 3
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create a HeadColumn table as below:

    Then try this measure:

    Measure = SWITCH(SELECTEDVALUE(HeaderTable[Value]),"_Selection 1",SUM(Source[Selection 1]),"_Selection 2",SUM(Source[Selection 2]),"_Selection 3",SUM(Source[Selection 3]))

    Choose [Value] as a slicer, then choose [Value] and this measure as a matrix visual.

    When you select one value in slicer, the result shows:

    Here is my test pbix file:

    pbix 

    Hope this can help.

     

    Best Regards,

    Giotto Zhi

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - Pretty sure the answer to this is still "no". 🙂

     

    But maybe someone has a nifty way around it, I just can't think of a way.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Oh, just had an idea. You could achieve this if you used 3 buttons, 3 bookmarks and stacked visuals. So, create a visual that displays only one of your columns. Stack them on top of one another. Use the Bookmarks and Selection panes to create 3 bookmarks where you show only one of the visuals and hide the other 2. Tie your Selection buttons to these bookmarks.

     

    It's funny too, because I actually started writing that measure that you did and stopped because I knew it wouldn't work!! 🙂

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    Please try to create a HeadColumn table as below:

    Then try this measure:

    Measure = SWITCH(SELECTEDVALUE(HeaderTable[Value]),"_Selection 1",SUM(Source[Selection 1]),"_Selection 2",SUM(Source[Selection 2]),"_Selection 3",SUM(Source[Selection 3]))

    Choose [Value] as a slicer, then choose [Value] and this measure as a matrix visual.

    When you select one value in slicer, the result shows:

    Here is my test pbix file:

    pbix 

    Hope this can help.

     

    Best Regards,

    Giotto Zhi

    • Dimitris_Kats's avatar
      Dimitris_Kats
      Helper V
      2 years ago
      • Hi. This works perfectly when you have only one measure in a matrix. How can I make it work with multiple measures??
      • Thank you