Create a dynamic measure column name

[Anonymous]

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):

Name	Measure
Item 1	1
Item 2	1
Item 3	1

Source Table:

Name	Selection 1	Selection 2	Selection 3
Item 1	1	2	3
Item 2	1	2	3
Item 3	1	2	3

Selection Table;

Column 1

Selection 1

Selection 2

Selection 3

[v-gizhi-msft · Accepted solution]

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]

• Hi. This works perfectly when you have only one measure in a matrix. How can I make it work with multiple measures??
• Thank you 

[Greg_Deckler]

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!! 🙂

[Greg_Deckler]

@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.