topic Re: VLOOK or similar in DAX Commands and Tips

VLOOK or similar

SamaS — Thu, 09 Feb 2023 14:51:27 GMT

Hello,

I am working on Power BI and specifically on its language. Today I have a small issue with identifying a value. To contextualize the situation, in my company each item has its own recipe, meaning its list of parameters to follow for the machine to work properly. I therefore have a huge file with each item's different parameters.

I would like to enter a DAX function that would allow me to see the value of the parameter as soon as I click on one of the items, and therefore have a column for each parameter.

The idea would then be to compare the parameter with its measurement. For example, for item 1, we must heat oven 2 to 130°, this column will be dynamic, that is to say if I click on item 2 the oven temperature may be 145°, each column will have its own parameter. The idea afterwards will be to create a column that compares the parameter with its measurement to identify potential inconsistencies or malfunctions.

Thanks a lo,

Re: VLOOK or similar

tamerj1 — Thu, 09 Feb 2023 16:50:52 GMT

SamaS

How does your data look like? Provide more information and perhaps screenshots of the data model along with the relationships along with some examples of the expected results.

Re: VLOOK or similar

SamaS — Fri, 10 Feb 2023 13:40:48 GMT

Sorry in advance, the report is in French. The idea is that the last column displays the value of the 4th column "valeur", following the selected "recipe" column 1, I am going to build a column for each "parametre" for example here the column: "Pre3_consigne brasseur sup COMP1 2_Recette (RPM). Regarding the script I am using Pre3_Consigne brasseur sup COMP 1 2_Recette (RPM) = CALCULATE( MAX(T_PRE3_Recette1[Value]), FILTER( T_PRE3_Recette1, T_PRE3_Recette1[Parametre 1] = "Pre3_Consigne brasseur sup COMP 1 2_Recette (RPM)" && T_PRE3_Recette1[Recette] = [Recette]

)). The problem is that the column only displays the max value for the parameter "Pre3_Consigne brasseur sup COMP 1 2_Recette (RPM)", and does not adapt to the "recette" column, the column is fixed and for the visuals it poses problems. "parametre" and "parametre1" are 2 identical columns

Re: VLOOK or similar

tamerj1 — Mon, 13 Feb 2023 11:16:00 GMT

Hi SamaS
I hope this is what you're looking for.

Pre3_Consigne brasseur sup COMP 1 2_Recette (RPM) = CALCULATE ( MAX ( T_PRE3_Recette1[Valeur] ), FILTER ( T_PRE3_Recette1, T_PRE3_Recette1[Parametre 1] = "Pre3_Consigne brasseur sup COMP 12_ Recette (RPM)" && T_PRE3_Recette1[Recette] = EARLIER ( T_PRE3_Recette1[Recette] ) ) )