Forum Discussion

Ackbar-Learner's avatar
Ackbar-Learner
Resolver I
3 years ago
Solved

Issue with Summarize in Power Pivot

Hi I am having with Summarize function in Power Pivot Dax

 

Below are four dependent measures one after the other. As you can see for the measure Projected Amount (EUR), the subtotals are correct but the last one just after tax is not deducting the tax. Please see the Dax for each measure below:

The issue seems to lie between the 2nd and 3rd measure. I cannot get the Summarize function to work correctly in the 2nd measure so that the 3rd measure (Running Total) can read it and apply same in its formula.

 

Any help would be greatly appreciated.

 

Best Regards

 

  • tamerj1's avatar
    tamerj1
    3 years ago

    Ackbar-Learner 
    Sorry I got distracted with some other business. 
    Please use the following for measure 2

    2nd Measure: =
    SUMX ( VALUES ( TabPLGLItem[GLItem] ), [TaxAmountWithSign] )