Incorrect Grand Column Total from Measure

[Anonymous]

Hello 

I have a matrix (below) and the Churn is calculated using the measure of:

Churn Measure =

  VAR __Churn = [Value in GBP on last day of Month (2 Months ago) V1] - [Value in GBP on last day of Month (Last Month) V1]

RETURN

    IF(__Churn > 2500,__Churn,0)

Where basically if v2 is more than 2,500 it returns a value. 

Although at row level it is calculating ok, the grand total is clearly wrong. 

Any ideas on how this can be fixed?

[Greg_Deckler · Accepted solution]

@Anonymous 

Churn Measure Total =
  VAR __Table = SUMMARIZE('Table',[CustomerReference],"__Churn",[Churn])
RETURN
  IF(HASONEVALUE('Table'[CustomerReference]),[Churn],SUMX(__Table,[__Churn]))