VLOOK or similar

[SamaS]

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,

[SamaS]

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

[tamerj1]

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] )
    )
)

[tamerj1]

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