show sum of positive and negative number separately from a variance measure

[Anonymous]

Hello Everyone,

I am trying to sum up only the positive value and negative value separately from a variance measure but the total in the table is showing the wrong total.

Add3 = IF([FTE - vs PM]>0,[FTE - vs PM],0)

Sub3 = IF([FTE - vs PM]<0,[FTE - vs PM],0)

Can anyone help me regarding these?

[v-easonf-msft]

Hi, @Anonymous 

Can you share your actual results and expected results for further research?

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi @Greg_Deckler, thanks for your quick response. But this does not solve my issue. I will try to explain my issue in detail.

I have a difference or variance measure created from a table and using that measure i.e. [FTE - vs PM] I am trying to get 2 additional showing a sum of positive numbers and negative numbers.

The solution provided works on a table but I need a solution that works on measure.

[Greg_Deckler]

@Anonymous The solution provided is specifically for measure totals in tables and matrices. You need to summarize or groupby the information by the individual row level and then do an aggregation like SUMX across that. Sample data would and expected output would enable the creation of a specific solution.

[Greg_Deckler]

@Anonymous 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