topic Re: How to change the base function in Dax in DAX Commands and Tips

How to change the base function in Dax

Anonymous — Sat, 02 Mar 2024 08:16:01 GMT

my calculations are as below.
Base = Sum( mydf[amount])
Function1 = Calculate([Base],....)
Function2 = Calculate([Base],....)
Function3 = Calculate([Base],....)
Total = Function1 + Function2 + Function3
###################
I would like change my Base functions as follows
Base_1 = SUMX( mydf, mydf[amount]*1 )
Base_2 = SUMX( mydf, mydf[amount]*2 )
and save them as Total_1 and Total_2
###################
If I wanna change the base function only once, I would just change it and the Total would be Total_1.
But how can i store it, if i wanna change twice efficiently ?

many thanks in advance.

Re: How to change the base function in Dax

Anonymous — Fri, 01 Mar 2024 22:39:08 GMT

I have a final dax function as Total. I would like to copy and save all the codes are needed to calculate to Total function.
Base = Sum( mydf[amount])
Function1 = Calculate([Base],....)
Function2 = Calculate([Base],....)
Function3 = Calculate([Base],....)
Total = Function1 + Function2 + Function3

How can i do that in power bi ?

Re: How to change the base function in Dax

lbendlin — Sat, 02 Mar 2024 00:59:52 GMT

Please describe what you mean by "copy and save". Power BI has no memory. There is nothing in DAX that would allow you to call external functions. The DAX paradigm for that is measures.

Re: How to change the base function in Dax

lbendlin — Sat, 02 Mar 2024 01:05:24 GMT

Staging is done in Power Query or further upstream, very rarely in DAX.

Re: How to change the base function in Dax

Anonymous — Sat, 02 Mar 2024 08:16:33 GMT

it is not what i am asking

Re: How to change the base function in Dax

lbendlin — Sat, 02 Mar 2024 12:29:18 GMT

I replied in your other post. DAX only has measures. Power Query has functions.