question

Claire-2499 avatar image
0 Votes"
Claire-2499 asked Lz-3068 edited

comment lier une mesure avec une table?

Bonjour
j'ai un souci pour faire un recherche v dans une table sur la base d'une mesure
- dans une formule je recupère le resultat d'un paramètre et d'un filtre que je concatene
(Simul Grade =
VARTest simulgrade = IF(HASONEVALUE(cpasseron_16[FAMILLE HAY REVUE.2]),SELECTEDVALUE(cpasseron_16[FAMILLE HAY REVUE.2],"0"),"NA")

Var Simul=('SIMULATEUR GRADE'[Valeur SIMULATEUR GRADE])

RETURN COMBINEVALUES( "-",simul,Test simul grade)

Exemple de resultat = 19-SC

Je souhaiterai après aller chercher une valeur en lien avec cette mesure dans une table pour renvoyer un resultat
ex= 19-SC = dans mon autre Table pour 19-SC => return 40 000(e)
(faire une recherchev dans une table à partir de ma mesure) mais je ne parviens pas à lier les 2

Pouvez vous m'indiquer comment procéder?
d'avance merci pour votre retour

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Lz-3068 avatar image
0 Votes"
Lz-3068 answered Lz-3068 edited

Hi/Bonjour @Claire-2499

English is currently the only language supported on this forum. Below is a translation (Bing Translator) of your question that hopefully reflects your ambition:

I have a problem to do a VLOOKUP in a table based on a measure. In a formula I collect the result of a parameter and a filter that I concatenate:

97937-simulgrade.png

Result example: 19-SC

I would like to then go and get a value related to this measure in a table to return a result
Ex. Use the returned value 19-SC as a lookup value in my other table - expected result in the case: 40 000(e)
(do a VLOOKUP in another table from my measure) but I don't see how to do it...

LOOKUPVALUE should do what you want. Should as there must be a single occurence of your lookup value (ex. 19-SC) in the <search_columnName>. Now, if there's a relationship between your 2 tables RELATED is a better option from an efficiency perspective

With LOOKUPVALUE your new measure should be something like:
97966-newmeasure.png

Hope this helps & next time if you want to raise your case in French I would recommend the MS FR Community



simulgrade.png (67.5 KiB)
newmeasure.png (46.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello
Thansk a lot it's Ok for me
Sorry I diddn't realize that I was on the .com website

best regards

0 Votes 0 ·

Hello @Claire-2499.

If "Thansk a lot it's Ok for me" means "problem solved" please Accept as answer to help others with a similar challenge
Thanks in advance and no worries re. the English forum, at least you know now :)

And BTW Dax Formatter could help you with long measures...


0 Votes 0 ·