Help with dax function

[ephramz]

Hi all,

I have this following measure

Total Arising V2 = VAR TAB = SUMMARIZE('ENGG VW_TRM','ENGG VW_TRM'[Functional Location],"Arising",MAX('ENGG VW_TRM'[Arising])) RETURN SUMX(TAB,[Arising])

and how can i change this to a calcualted column

or how to take the measure value and create a new calculated column

[Anonymous · Accepted solution]

Hi @ephramz ,

Hi @ephramz ,

You can create a calculated column to get your expected value.

Total Arising V2 = VAR _max=CALCULATE(MAX('ENGG VW_TRM'[Arising]),FILTER('ENGG VW_TRM',[Functional Location]=EARLIER('ENGG VW_TRM'[Functional Location]
)))
return IF(_max=[Arising],[Arising])

Best Regards,

Stephen Tao

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

[parry2k]

@ephramz if you have a dimension table for Functional Location then it will be easier.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡