Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Incorrect Grand Column Total from Measure

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 las...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous 

    Churn Measure Total =
  VAR __Table = SUMMARIZE('Table',[CustomerReference],"__Churn",[Churn])
RETURN
  IF(HASONEVALUE('Table'[CustomerReference]),[Churn],SUMX(__Table,[__Churn]))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous 

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