cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrewseaman
Helper II
Helper II

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
1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please try to create a HeadColumn table as below:

21.PNG

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:

22.PNG

Here is my test pbix file:

pbix 

Hope this can help.

 

Best Regards,

Giotto Zhi

View solution in original post

3 REPLIES 3
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please try to create a HeadColumn table as below:

21.PNG

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:

22.PNG

Here is my test pbix file:

pbix 

Hope this can help.

 

Best Regards,

Giotto Zhi

View solution in original post

Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors