Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
@Ackbar-Learner
Sorry I got distracted with some other business.
Please use the following for measure 2
2nd Measure: =
SUMX ( VALUES ( TabPLGLItem[GLItem] ), [TaxAmountWithSign] )
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]
)
@Ackbar-Learner
Sorry I got distracted with some other business.
Please use the following for measure 2
2nd Measure: =
SUMX ( VALUES ( TabPLGLItem[GLItem] ), [TaxAmountWithSign] )
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.
@Ackbar-Learner
You were blanking out the total using HASONEVALUE which was absolutely unnecessary
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
9 | |
9 |