Forum Discussion

The_Marc_Rohde's avatar
The_Marc_Rohde
Frequent Visitor
1 year ago

Total not working with visual calculation

I am using the visual calculation feature and am getting inconsistent results with totals on the bottom of a table.  I have two calculations in the same table and one is totaling and the other isn't....
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi The_Marc_Rohde , hello lbendlin, thank you for your prompt reply!

Based on my test, the visual calculation functions as demonstrated below:

Additionally, we could format a visual calculation using data types and formatting options as shown below:

 

Please update the power bi desktop to the latest version to compare the result.

 

More information for your reference:

 

Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn

 

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

The_Marc_Rohde's avatar
The_Marc_Rohde
Frequent Visitor
1 year ago

I have the same settings with different results.  The calculated columns other than the last are working fine.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi The_Marc_Rohde, 

     

    Thank you for your feedback.

     

    If possible, please upload a sample pbix file without sensitive information for further troubleshooting.