Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure not changing value with decomposition tree

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
 
 

Decomposition Tree Visual

DAX
Decomposition Tree

3 Replies

  • spg_vizcube's avatar
    spg_vizcube
    Icon for Helper II rankHelper II
    6 years ago

    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? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

      • spg_vizcube's avatar
        spg_vizcube
        Icon for Helper II rankHelper II
        6 years ago

        What is eating the memory? did you try performance analyzer