topic Re: Measure not changing value with decomposition tree in DAX Commands and Tips

Measure not changing value with decomposition tree

Anonymous — Wed, 15 Jul 2020 10:55:52 GMT

Hello,

I need some help. I have a measure which is calculated as

Realization = DIVIDE([Net Revenue],[Production])

The above two factors contributing to Realization are caluclated as

Net Revenue = [Production]+[Variance]+SUM('star factWIPProvision'[Amount])

Production = SUMX('star factWIP',IF(ISBLANK('star factWIP'[TimeProduction]),0,'star factWIP'[TimeProduction])+IF(ISBLANK('star factWIP'[ExpenseProduction]),0,'star factWIP'[ExpenseProduction])+IF(ISBLANK('star factWIP'[JobTypeAllocationProduction]),0,'star factWIP'[JobTypeAllocationProduction]))

The Variance is Calculated as

Variance = SUM('star factWIP'[WriteUpDownAmount])

Now my question is I am using a decomposition tree to see the realization value across different hierarchy but the value doesnt change, its showing same across all hierarchy

Re: Measure not changing value with decomposition tree

spg_vizcube — Wed, 15 Jul 2020 11:03:05 GMT

From the formulae, I thinking this has to do with the context of the formula, because the production formula seems to be working on a table context. You might want to use a simple Table visual and pull different measures to see if they change?

Re: Measure not changing value with decomposition tree

Anonymous — Wed, 15 Jul 2020 11:04:47 GMT

Simple Table is not working as it gives Out of memory error in PBI desktop as well as in service

Re: Measure not changing value with decomposition tree

spg_vizcube — Wed, 15 Jul 2020 11:06:57 GMT

What is eating the memory? did you try performance analyzer