Forum Discussion
SilviaM
4 years agoFrequent Visitor
Get total sum Help!
Hi, I need your help on this issue. I have information in a table named ALL DATA of Revenue about WBS, area, and month. Due to a WBS can have more than 1 area, revenue data is the same in t...
- 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
Ashish_Mathur
4 years agoSuper User
Hi,
Share the link from where i can download your PBI file.
SilviaM
4 years agoFrequent Visitor
I can't share the pbxi 😞 i don't have any site to do it. Sorry about that!