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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.