Avoid cummulative values on a line graph

Hi Anonymous ,

In this case you can do one of two things:

1. Add a column to your original table with the following syntax:

Country / Continent = Geography[ContinentName] & "|" & Geography[RegionCountryName] 

Use this column on the legend of your line chart and the other two columns on the slicers.

2 Crate a table has the two columns in the same table and then change the measure to pick up those values the table will be something similar to:

Continent/Region = 
ADDCOLUMNS (
    SUMMARIZE ( Geography, Geography[RegionCountryName], Geography[ContinentName] ),
    "ID",Geography[ContinentName] & "|" & Geography[RegionCountryName] 
)

This table will look like this (table of unique conditions between country and continent):

Now redo your measure to:

Dinamic Axis Sales_ = 
        SUMX (
            FILTER (
                SUMMARIZE (
                    sales,
                    Geography[RegionCountryName], Geography[ContinentName],
                    "TotalSales", SUM ( Sales[SalesAmount] )
                ),
                Geography[RegionCountryName]
                    = SELECTEDVALUE ( 'Continent/Region'[RegionCountryName] ) &&
                Geography[ContinentName]
                    = SELECTEDVALUE ( 'Continent/Region'[ContinentName] ) 
            ),
            [TotalSales]
        )

Use the ID column on your legend and the other two columns on the slicers: