Slicer for line chart - how to show 3 options and-or a sum of all options?

[Baddeck]

ie a slicer & line chart (months on x-axis) with lines for Texas, Oklahoma, and Arkansas, with an option to show just one line showing the sum of all 3. Total line/option has me stumped. Select All shows 3 lines not 1

[Ritaf1983 · Accepted solution]

Hi @Baddeck .
You can choose between the countries and the total by using field parameters.
This is how it works:
1. Create measure for every country using "calculate" function :

SumArkansas = CALCULATE(sum('Table'[value]),'Table'[Country]="Arkansas") 
2. Create measue for "Total"

SumTotatal = CALCULATE(sum('Table'[value]),all('Table'[Country]))
3. Create a field parametrs with your measures

4. Put a parametr that you created as a value of Y axis on your line chart:

 results:

I have also prepared a sample file.
Here is the link to download it:
https://drive.google.com/file/d/1xhVXFE-b2yfTw0qs6zyLCs1itSaPhITf/view?usp=sharing 

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