How to get the sum of this column? Keeps giving me a 0

[xozelda11]

How do I get the actual total margin uplift column to give me the sum of the column as the total instead of 0?

Normalized Forecasted Sales Volume =
VAR _Forecast = [Sales Volume (Actuals + Forecast)]
VAR _TotalSales =
[Total Sales Volume]

VAR _NormalizedAssetProd =
sum('Normalized Asset Production'[Avg 2019-2021,2024]) * 1000000
RETURN
DIVIDE(_Forecast, _TotalSales) * _NormalizedAssetProd

Normalized Forecasted Sales Volume LY =
VAR _Forecast = [Sales Volume Last Year]
VAR _TotalSales =
[Total Sales Volume LY]

VAR _NormalizedAssetProd =
sum('Normalized Asset Production LY'[Avg 2019-2021,2024])
RETURN
DIVIDE(_Forecast, _TotalSales) * _NormalizedAssetProd

Sales Volume Variance =
CALCULATE(
[Normalized Forecasted Sales Volume] - [Normalized Forecasted Sales Volume LY]
)

EBITDA Gain Loss =
CALCULATE(
[EBITDA Domestic Prime] - [EBITDA Forecast Export Prime Total]
)

Actual Total Margin Uplift =

[Sales Volume Variance] * [EBITDA Gain Loss]

EBITDA Forecast Export Prime Total =
CALCULATE(
[EBITDA - Forecast (cpp)],
'DIM Project Metrics'[Finance Grouping] IN { "export-prime" },
'DIM Project Metrics'[Market Role] = "pivotal"
)

EBITDA Domestic Prime =
CALCULATE(
[EBITDA - Forecast (cpp)],
'DIM Project Metrics'[Finance Grouping] IN { "domestic-prime" }
)

these are all measures in my current dashboard table, what do i have to fix out of these measures to get a total to show up for actual total margin uplift column? Please help!

[v-pnaroju-msft]

Hi xozelda11,

We are following up to check whether you have raised the support ticket. If you have already done so, we kindly request you to share your feedback on the issue raised.
If a solution has been provided, we would appreciate it if you could share it with the community and mark it as the accepted solution. This will help others facing similar challenges and benefit the broader community.

Thank you.

[v-pnaroju-msft]

Hi xozelda11,

We are writing to kindly follow up and inquire whether you have raised the support ticket. If you have already done so, we would appreciate it if you could share your feedback regarding the issue raised.

In case a solution has been provided or if you have resolved the issue, we would be grateful if you could share the details with the community and mark it as the accepted solution. This will assist others facing similar challenges and be of benefit to the wider community.

Thank you.

[v-pnaroju-msft]

Hi xozelda11,

We are following up to check whether you have raised the support ticket. If you have already done so, we kindly request you to share your feedback on the issue raised.
If a solution has been provided, we would appreciate it if you could share it with the community and mark it as the accepted solution. This will help others facing similar challenges and benefit the broader community.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi xozelda11,

We sincerely apologize for the inconvenience caused.

As the issue is still not yet resolved, we kindly request you to raise an issue at Issues - Microsoft Fabric Community for investigation.
Otherwise raise a Microsoft support ticket using the link provided below. They will be able to provide specific insights related to your account and potential resolutions.
Microsoft Fabric Support and Status | Microsoft Fabric

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[v-pnaroju-msft]

Hi xozelda11,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[xozelda11]

Hi, this solution does not work unfortunately. 

[v-pnaroju-msft]

Thank you, @Shravan133, @Ashish_Mathur, for your response.

Hi @xozelda11,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Please find attached the screenshot and PBIX file, which may help in resolving the issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members who may have similar queries.

Thank you.

[xozelda11]

Normalized Forecasted Sales Volume =
VAR _Forecast = [Sales Volume (Actuals + Forecast)]
VAR _TotalSales =
[Total Sales Volume]

VAR _NormalizedAssetProd =
sum('Normalized Asset Production'[Avg 2019-2021,2024]) * 1000000
RETURN
DIVIDE(_Forecast, _TotalSales) * _NormalizedAssetProd

Normalized Forecasted Sales Volume LY =
VAR _Forecast = [Sales Volume Last Year]
VAR _TotalSales =
[Total Sales Volume LY]

VAR _NormalizedAssetProd =
sum('Normalized Asset Production LY'[Avg 2019-2021,2024])
RETURN
DIVIDE(_Forecast, _TotalSales) * _NormalizedAssetProd

Sales Volume Variance =
CALCULATE(
[Normalized Forecasted Sales Volume] - [Normalized Forecasted Sales Volume LY]
)

EBITDA Gain Loss =
CALCULATE(
[EBITDA Domestic Prime] - [EBITDA Forecast Export Prime Total]
)

Actual Total Margin Uplift =

[Sales Volume Variance] * [EBITDA Gain Loss]

EBITDA Forecast Export Prime Total =
CALCULATE(
[EBITDA - Forecast (cpp)],
'DIM Project Metrics'[Finance Grouping] IN { "export-prime" },
'DIM Project Metrics'[Market Role] = "pivotal"
)

EBITDA Domestic Prime =
CALCULATE(
[EBITDA - Forecast (cpp)],
'DIM Project Metrics'[Finance Grouping] IN { "domestic-prime" }
)

these are all measures in my current dashboard table, what do i have to fix out of these measures to get a total to show up for actual total margin uplift column? Please help!

I need the rows to equal to the actual total margin uplift column that you see in the screenshot so the formula works but its not providing the correct row by row calculation.

[xozelda11]

<iframe title="ME Mix Uplift Wave Tracking Dashboard" width="1140" height="541.25" src="https://app.powerbi.com/reportEmbed?reportId=a2a1eb5c-8a44-4193-9b7f-7aa71c2cf76a&autoAuth=true&ctid=0d396c31-441f-4e16-a6e6-3b017f2f63d1" frameborder="0" allowFullScreen="true"></iframe>

[xozelda11]

Please send me an email at renegader222@gmail.com so I can send the powerbi file there 

[xozelda11]

https://app.powerbi.com/reportEmbed?reportId=a2a1eb5c-8a44-4193-9b7f-7aa71c2cf76a&autoAuth=true&ctid...

Please let me know if this works 

[Ashish_Mathur]

That takes me to a sign-in page.

[Shravan133]

You need to sum your values per row. try using sumx or summarize.

Actual Total Margin Uplift =
SUMX(
VALUES('YourTable'[KeyColumn]), // column that defines each row uniquely
[Sales Volume Variance] * [EBITDA Gain Loss]
)

[xozelda11]

I used this formula but its not giving me the correct line by line calculation..

Actual Total Margin Uplift Total =

SUMX(

    VALUES('DIM Project Metrics'[Index]),

    [Sales Volume Variance] * [EBITDA Gain Loss]

)

[Shravan133]

Try this:

Actual Total Margin Uplift =
IF(
ISINSCOPE('DIM Project Metrics'[Index]),
-- Row-level calculation (simple multiplication)
[Sales Volume Variance] * [EBITDA Gain Loss],

-- Total-level calculation (SUMX over all rows)
SUMX(
VALUES('DIM Project Metrics'[Index]),
[Sales Volume Variance] * [EBITDA Gain Loss]
)
)

please provide sample data and screenshots if it doesnt work

[xozelda11]

I need the rows to equal to the actual total margin uplift column that you see in the screenshot so the formula works but its not providing the correct row by row calculation.

Please see above for the measures I used

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Show the problem there very clearly.

[xozelda11]

https://app.powerbi.com/reportEmbed?reportId=a2a1eb5c-8a44-4193-9b7f-7aa71c2cf76a&autoAuth=true&ctid...