Forum Discussion
Solved
Table total incorrect for measures
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:
Hi arielliu ,
I'd like to suggest you take a look at below blog about measure total calculations:
Measure Totals, The Final WordRegards,
Xiaoxin Sheng
4 Replies
Hi arielliu ,
I'd like to suggest you take a look at below blog about measure total calculations:
Measure Totals, The Final WordRegards,
Xiaoxin Sheng
Thanks! My issue is resolved with the solution in the article from your link.
- 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]])
