IF Condition wrong Total

[Anonymous]

I m trying to do a total of income but the total number is coming wrong can anyone help me.

Income Increases = 
//=IF(LEFT(A8,1)="4",IF(B8<C8,(C8-B8),0),0)
Var _Base = CALCULATE([Base Switch],FILTER(Real_Data,Real_Data[GLSubAccountTypeName]="Income"))
Var _Comp = CALCULATE([Comp Switch],FILTER(Real_Data,Real_Data[GLSubAccountTypeName]="Income"))
Var _logicTest = IF(_Base>_Comp,1,0)
Var _logic = IF(_Base>_Comp,(_Base-_Comp),0)
Return
_logic

[VahidDM · Accepted solution]

HI @Anonymous 

Please check this post:

https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

@Greg_Deckler can please check it

[Greg_Deckler]

@Anonymous This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.