Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I created a measure that calculates the value based on a selection. However, I need my measure title to be dynamic as well.
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 |
Solved! Go to 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:
Hope this can help.
Best Regards,
Giotto Zhi
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:
Hope this can help.
Best Regards,
Giotto Zhi
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!! 🙂
@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.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |