Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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 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?
 

soochoilondon_0-1663591639634.png

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@Anonymous 

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

@Anonymous 

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors