topic Re: Lookupvalue and filter. in DAX Commands and Tips

Lookupvalue and filter.

Anonymous — Wed, 27 Jul 2022 21:26:48 GMT

Hi everybody, i have some question about this.

I have a table that contain multiple columns (Market, Despatch, etapa1). i have 1 MARKET, and a lot of despatch.

I need to find de max value of "ETAPA 1" Referred to each "DESPATCH" for example, in this case

And then calculate the addition with the max values

Re: Lookupvalue and filter.

Jihwan_Kim — Thu, 28 Jul 2022 03:43:34 GMT

Hi,

Please check the below picture and the attached pbix file.

It is for creating new columns.

MAX Etapa1 CC = VAR _maxetapa1 = MAXX ( FILTER ( Data, Data[Market] = EARLIER ( Data[Market] ) && Data[Despatch] = EARLIER ( Data[Despatch] ) ), Data[Etapa1] ) VAR _condition = Data[Etapa1] = _maxetapa1 RETURN DIVIDE ( _condition, _condition ) * _maxetapa1

Re: Lookupvalue and filter.

v-xiaotang — Mon, 01 Aug 2022 02:22:03 GMT

Hi Anonymous

Thanks for reaching out to us.

>> And then calculate the addition with the max values

You can try this, create the 2 measures

Max_PerMarDes = var _maxEta=CALCULATE(MAX('Table'[Etapa1]),ALLEXCEPT('Table','Table'[Market],'Table'[Despatch])) return IF(MIN('Table'[Etapa1])=_maxEta,_maxEta)

sum = SUMX('Table',[Max_PerMarDes])

result

Best Regards,

Community Support Team _Tang

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