Add a Grand Total column to a stacked column chart

Hi Zer0Fear1 ,

Thanks for connecting with the Microsoft Fabric Community Forum.

Try using this DAX query, it will work for you. Here is the DAX Measure you can use

Grand Total = SUM(sheet1'[Cost])

                             (or)

Grand Total Series = CALCULATE(SUM('YourTable'[Cost]), ALL('YourTable'[Date]))

Now, you can add Grand total  to the card visual and view.

For your Idea, I’ve attached the PBIX file with the implemented solution. Please review it and let us know is there any further questions.

If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.

Please Accept as solution If this post clears your issue and a Kudos would be appreciated.

Thankyou.