Table total incorrect for measures

[arielliu]

I have a table of fact with 5 columns. The last 3 columns are measures as below. In Power BI, the total of those measures are not correct for some reason. I couldn't figure out why. Can someone help please? screenshot link in below.

Forecast left to ship = if(CALCULATE([Lower of forecast or commit]-[Sum Billing QTD])>0, CALCULATE([Lower of forecast or commit]-[Sum Billing QTD]),0)

Lower of forecast or commit = if([Sum Supply Commit]=0,[Sum Sales Forecast],(IF([Sum Sales Forecast]<=[Sum Supply Commit],[Sum Sales Forecast],[Sum Supply Commit])))

Forecast left to ship = if(CALCULATE([Lower of forecast or commit]-[Sum Billing QTD])>0, CALCULATE([Lower of forecast or commit]-[Sum Billing QTD]),0)

Data screenshot:

https://imgur.com/oLXM0gv 

[v-shex-msft · Accepted solution]

Hi @arielliu ,

I'd like to suggest you take a look at below blog about measure total calculations:
Measure Totals, The Final Word  

Regards,

Xiaoxin Sheng

[arielliu]

Thanks! My issue is resolved with the solution in the article from your link.

[PaulDBrown]

@arielliu

Try the following syntax, including each of your measures in separate new measureS:

Sum of columns = SUMX(SUMMARIZE(table, Table[product], “sum of measure”, [your measure]), [sum of measure]])

[arielliu]

My PBIX file is attached here:

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=643&MessageK...