Forum Discussion

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 b...

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] )

Community Champion

3 years ago

Hi Ackbar-Learner
Try to add the equal sign

Resolver I

3 years ago

tamerj1 no effect mate🤔

tamerj1
Community Champion
3 years ago
Hi Ackbar-Learner
Would you please copy/paste the code of the four measures?
- Ackbar-Learner
  Resolver I
  3 years ago
  Sure tamerj1
  1st Measure:
  =VAR Result = [AmountWithSign]
  VAR TaxApplicable = -1*if([TaxCalcCumulative]>[TaxCalcPeriod],[TaxCalcPeriod],[TaxCalcCumulative])
  RETURN
  calculate(if(if(HASONEVALUE(TabPLGLItem[GLItem]),values(TabPLGLItem[GLItem]))="Tax",TaxApplicable,Result))
  
  2nd Measure:
  =VAR CorrectTotal = SUMMARIZE(TabPLGLItem,[GLItem],"__value",[TaxAmountWithSign])
  RETURN
  IF(HASONEVALUE(TabPLGLItem[GLItem]),[TaxAmountWithSign],SUMX(CorrectTotal,[__value]))
  
  3rd Measure:
  =if(
  HASONEFILTER(TabPLGLItem[GLItem])
  ,
  CALCULATE(
  [PLTaxAmountWithSign]
  ,
  ALL(TabPLGLItem[GLItem])
  ,
  TabPLGLItem[Index] <= VALUES(TabPLGLItem[Index])
  )
  ,
  blank()
  )
  
  4th Measure:
  =SWITCH(
  [HeaderCalcType]
  ,
  BLANK(),BLANK()
  ,
  1,[TaxAmountWithSign]
  ,
  2,[RunningTotal]
  )
  - tamerj1
    Community Champion
    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] )

Related content