Maximize a function in DAX

[Anonymous]

Hello all, 

Do you know if we can with DAX crete maximize or minimize functions based on conditions? I´ve tried everythin, and i looked in Internet and i didn´t found anything.

I want to find the Maximun value of one parameter that i created (from 0 to 1 plus 1 I.e 1.16%) that makes my Budget - Cost more close to 0.

It could be great if we can add to our datamodels that kind of stuff.

Thank you!!   

[Anonymous · Accepted solution]

Hi @Anonymous

If you want to get the maximize/minimize value from condition, I think you can convert this formula and use this condition as the filter.

For example:

Original= IF(Table[Column1]>0,max(table[Amount]),0)
↓
New= Calculcate(max(table[Amount]),FILTER(ALL(Table),Table[Column1]>0))

If above not help, can you please provide some sample data? 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

I would create an Enter Data query with the values that you want to analyze and then create a column or measure that does your calculation and then plot that. I may not be understanding what you are going for. You can also maybe take a look at the new "What If" parameters that they added to Power BI in August.