Measures multiplication not working

mtrilho — Wed, 19 Apr 2023 14:41:55 GMT

Hi!

I want to update a cost (base cost) from a reference period to the latest period available using the DCCI Index. The final result should give me the capitalized cost.

To make this dynamic (I want to be free to choose any combination of references and latest period), I have created the following:

a measure to return the reference period based on a filter:
reference period = SELECTEDVALUE('Reference Period'[QY_reference])
a measure to return the latest period based on a filter:
latest period = SELECTEDVALUE('Latest Period'[QY_latest])
a measure to return the respective DCCI index for the selected periods:
DCCI_latest = LOOKUPVALUE(DCCI[DCCI],DCCI[QY],'Latest Period'[latest period])
DCCI_reference = LOOKUPVALUE(DCCI[DCCI],DCCI[QY],'Reference Period'[reference period])

At this point, these measures are working:

Now, I want to multiply the base cost (Electrical Labour Cost USD -> this is another measure, it's the sum of the electrical labour base cost column) by the ratio of these indexes (DCCI_lateste / DCCI_reference).
I typed the following function but it doesn't work I cannot understand what I need to change:

Electrical Labour Capitalized Cost USD = DIVIDE( [Electrical Labour Cost USD]*DCCI_reference , [DCCI_latest]) )

Any thoughts about this?

Thanks in advance!

Mónica Trilho

topic Measures multiplication not working in DAX Commands and Tips

Measures multiplication not working