Select a measure based on a filter selection

[andreazambon]

Hi there. 

I have a groups of machines which requires a measure based on meters and a group of machines which need the same measure but based on kilograms, and I don't want to create a twin-dashboard to show my data. 

My intenction is to work with a filter view where I can choose the groups of machines and based on my selection, use the rigt measure. 

For instance, something like (pseudo-code) 

Measure_um = if(Group = A || Group = C;"MeasureMeters";"MeasureKg")

Do you know if this strategy is feasible? 

Thankyou!

[andreazambon]

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

[khaledHabib90]

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 🙂

[andreazambon · Accepted 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. 

[Greg_Deckler]

@andreazambon Right, so generally this is done like the following:

Measure_um = 
  VAR __Group = SELECTEDVALUE('Table'[Group])
  VAR __Return = 
    SWITCH( TRUE(), 
       __Group = "A" || __Group = "C", [MeasureMeters],
       [MeasureKg]
    )
RETURN
  __Return