Sales by Regional & National Avg

When attempting to recreate this visual I am struggling to create a regional average & national average. When I do average(sales) I am getting the avg transaction rather than the avg of the sum of sales. Is there a way to recreate this visual?

Hi @kurzashane you will need to supply a PBIX File for us to help you properly, not much information to go on.

Hi @kurzashane, as @DavieJoe said above, providing a PBIX file will help users and experts find a solution to your inquiry faster and better.

A perfect initial question includes all of the following:

  • A clear explanation of the problem you are experiencing

  • A mockup of the results you want to achieve

  • Your current work-in-progress PBIX file

  • Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)

Check out this thread on Tools and Techniques for Providing PBIX Files with Your Forum Questions

Not completing your data may sometimes cause delay in getting an answer.

1 Like

Hi @kurzashane, we’ve noticed that no response has been received from you since September 1.

We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Apologizes @DavieJoe Attached is the excel document that I have been using.
exampleds.xlsx (26.3 KB)

Ideally when the user from Region 1 logs in the graph will show their site avg compared against their regional and national avg for revenue.

1 Like

Hi @kurzashane as this post, due to inactivity, was marked as solved it would be to your benefit if you recreated this post in a new thread so others can find this post easily.