Forum Discussion
Select a measure based on a filter selection
I use the custom visual "Toggle switch by TME AG" to switch between the values of a new table (with 2 elements, "m" and "kg"), and with the selected value, I change all the measures.
Your solution is a bit risky because in my dashboard I have different views, each one uses a different measure expressed in m or kg.
Greg_Deckler , thanks for your answer.
Making the analysis, I've find out that is more complicated than i thought and than I described in my first post.
The real situation is that only one group of machines needs to be valued in meters (GROUP A). If I need to select machines from differents groups and one of those groups is the group A, I need measure in kg.
I managed this in a great way, with this trick:
1) create a measure with meters;
2)create a second measure equal to the first one but with kgs;
3) create a third measure with the condition (pseudocode):
if( and(SELECTEDVALUE(GroupTable[group])="A",[count_selected_groups]=1), Measure2, Measure1)
and it works fine!
Anyway, iI think that this is very restrictive. So I thought to create a measure wich contains only 2 values: "m" and "kg", and use a slicer based on that selection to swap the measure.
If I can ask.... how can I make that measure?
I tried with
Measure = {"m","kg"}
nut it does not work 😛
if you want a slicer selection to switch the measures, consider using Field parameters, you will add bother your measures in and then add a slicer with the field parameter to switch
however now in your visuals you will need to have the field parameter as the value in your visuals instead of the old measures
If I answered your question please accept the reply as the solution 🙂
I use the custom visual "Toggle switch by TME AG" to switch between the values of a new table (with 2 elements, "m" and "kg"), and with the selected value, I change all the measures.
Your solution is a bit risky because in my dashboard I have different views, each one uses a different measure expressed in m or kg.