Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Total Line Bar Chart

Hello, I have a database in which sales to different countries and in different years appear. I have created a graph with the TOP 4 countries to which the most quantity has been sold (on the 'y-axis...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Syndicate_Admin ,
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    1. Create a measure

    Total Sales = CALCULATE(SUM([Sales]), REMOVEFILTERS('Table'[Sales],'Table'[Year]))

    2.Choose Line and clustered column chart


    Final output

     

     

     

    Best regards,

    Albert He

     

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

     



Jonvoge's avatar
Jonvoge
Most Valuable Professional
2 years ago

Hi!

 

You'll need to create a Calculated Measure like the following, to return the total sales for all countries:

 

Measure = 

Calculate(Sum(SalesAmount), All('Table', 'Table'[Country])

 

The 'All' function removes all filters from the Country column.

Try the above measure in your visual, and see if it works!

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data