Forum Discussion

Milozebre's avatar
Milozebre
Helper V
6 years ago
Solved

Use variable in measure

Hello Community,    I hope you are well and that containment is not too difficult. I have a problem with the parameters and my measurements. I am doing my math class and I would like to make a ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Milozebre ，

     

    You can modify your formula as below:

     

    Measure = SWITCH(SELECTVALUE(SI(GAUCHE(CV_calculation_rule;1)),"1";SELECTEDVALUE(CK2);
"2";SELECTEDVALUE(CL2);"4";SELECTEDVALUE(CM2);RECHERCHEV(A2;'Comp database'!A:V;22;0))

     

    I'm not sure what does "SI""GAUCHE""RECHERCHEV"mean?Are they all tables' names?The measure can be simply described as :

     

    measure= SWITCH([measure],"case 1","value 1","case 2,"value 2",...[else])

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
You seem mad at me about something Milozebre , I am not sure why. I try to answer questions as best I can and have been doing it for like 5 years now. I have over 2,500 confirmed solutions authored so some people seem to find what I post valuable. I replied to your private message.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

In the hopes others may benefit:

 

I suggested using a slicer or buttons. If you use a slicer, you would do something like create a slicer table like:

 

Choices

Options
Option1
Option2
Option3
Option4

 

And then a measure like:

 

Measure = 

  SWITCH('Choices'[Option],

    "Option1",<some calculation>,

    "Option2",<some other calculation>,

    "Option3",<some other other calculation>,

    "Option4",<some other other other calculation>

  )

 

So, for the <some calculation> stuff, those would be good if each of those was a separate measure that handled it.

 

I am still not sure I understand the actual question though or what you are going for.