Forum Discussion
Get total sum Help!
- 4 years ago
SilviaM This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907 - 4 years ago
Hi SilviaM
will it help? the sample file attached below.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- 4 years ago
Does this work?
New Rev by WBS = SUMX ( 'Table', CALCULATE ( IF ( MAX ( 'Table'[Area] ) = "Servers", DIVIDE ( SUM ( 'Table'[sum of Rev] ), 2 ), SUM ( 'Table'[sum of Rev] ) ) ) )and
% of Revenue = VAR total = CALCULATE ( [New Rev by WBS], FILTER ( ALL ( 'Table' ), 'Table'[Area] <> "Servers" ) ) RETURN IF ( MAX ( 'Table'[Area] ) = "Servers", BLANK (), IF ( ISINSCOPE ( 'Table'[WBS] ), DIVIDE ( [New Rev by WBS], total ), DIVIDE ( DIVIDE ( [New Rev by WBS], 2 ), total ) ) )to get
SilviaM This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
- SilviaM4 years agoFrequent Visitor
Hi Greg,
Thanks fo rthe quick response and help, i tried to use the formula but i got noticed that also in the column Rev Real by WBS is duplicated by month, so if i tried again use the formula now to get the sum of all max values in that column i got the same value and i need it to stay fixed in order to multiplied it by Rev Real by WBS and get the %Revenue
Rev Real by WBS=
var tableop= summarize('ALL DATA','ALL DATA'[Year_Month],"REVS",sumx(values('ALL DATA'[Year_Month]),max('ALL DATA'[Value])))returnif(HASONEFILTER('ALL DATA'[Year_Month]),sumx(tableop,[REVS]))TOTAL= if(HASONEFILTER('ALL DATA'[wbs]),sumx('ALL DATA',[Rev Real by WBS])) here i need also to get just 1 value not sum the duplicated. Because the total is 2,700,501.8 and it's giving me 8,101,505.64
I thinks i'm doing something wrong,