Need assistance on Dax

[Nihed]

Hello Experts 🙂

I have a small issue, i have a table with multiple columns, the Column "Potential" is the target one. , i want to identify the minimum number of this column , once identified, i want to have the columns "Label" & "Potential" associated to the line which contains the minimum number appear on another table   . Instead of that I'm having the total appears (on second table year 2020) not the minimum number.

I already used minx potential, but no luck 😞

Any help please? 

[Icey]

Hi @Nihed ,

Since you said that potential is a measure and you want to get its minimum value, how about creating another measure like below?

Measure =
MINX ( VALUES ( 'YourTable'[Year] ), [potential] )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Icey]

Hi @Nihed ,

Can this work?

Best Regards,

Icey

[VahidDM]

Hi @Nihed 

Can you share a sample of your data in a table format?
BTW, change the aggregation of Potential in the below matrix to the Min then you can find the result if your data table is like the top table in the image you shared.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Nihed]

thank you for your repy, i have tried the min, but it does not work, potential it's a measured column below formula : 

Potential =

VAR _RSEv=[Remaining stock per SY]*[EvaporationLoss]

VAR _Prc=SUM(Demands[Percentage])

VAR _STR=SUM(Brand[Strength])

Return

divide(divide(_RSEv , _Prc ) , _STR) /9

link to download the csv file example : https://wetransfer.com/downloads/e1391cabfd964b1903900b42e3391db220211010095548/0aa3cf20c84d1c586c54...