Forum Discussion

Ackbar-Learner's avatar
Ackbar-Learner
Icon for Resolver I rankResolver 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...
Need Help
  • 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] )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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] )
Ackbar-Learner's avatar
Ackbar-Learner
Icon for Resolver I rankResolver I
3 years ago

This was so easy and I went to fetch it on the moon😃. Any clue why did the Summarize function not work?

 

Also, would you mind explaining what is actually the above function doing? This will be for the benefit of people who will read this afterwards and myself as well.

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Ackbar-Learner 
    You were blanking out the total using HASONEVALUE which was absolutely unnecessary