Statewide With Counties In Same Bar Chart

[quantran]

I have a bar chart that has statewide data as well as counties (see image below).  Following are the fields that I used for this image.  The New York County field does not have Statewide.

I was wondering what is the best way to set this up?

Thank you.

Field Name	Description	Example
Date Field	Has the field to calculate the years Have 2019, 2020, 2021, and 2022 data	1/1/2019, 1/2/2019, 1/3/2019
New York County	Has the counties for New York Does not have Statewide	Central, Hudson Valley, Long Island
Count Field	This field has a value for all rows in the report so that all rows are counted

[quantran · Accepted solution]

I was able to do this by following this video on how to add Totals:

Bonus How to add Totals to a bar chart visualizations using DAX

https://www.youtube.com/watch?v=fJzQiXF4kGs

[quantran]