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!

     

Milozebre's avatar
Milozebre
Helper V
6 years ago

Dear community, 

 

I close my request without having had the answer to my question following a message from a member, he will recognize himself.

I thank the two people who took the time to answer me. It is a community but apparently for some reserved for a certain category of people with a level other than mine.

 

Stay safe,

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Milozebre , Not all questions are answerable. Seems like you had 3 people attempt to help. It's only been a day!
    • Milozebre's avatar
      Milozebre
      Helper V
      6 years ago

      you want an explanation on the forum?

      OK.

      Two people tried to help me and I thanked them.

      You, with your habit, you don't answer, a track in the vague or then to read a page of the forum to be made help faster but then, one does not see you any more.

      I sent you a message already. I haven't said anything before.

      I imagine all the people who are waiting for help and who are reading you.

      You may be good, but your pedagogy is not intended for the audience.

      If I find the solution, this will be your 121 DAX recipes.

       

      And saying hello never killed anyone.

       

      Have a nice day. 

      • 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.