Avoid cummulative values on a line graph

Hi Anonymous ,

Believe this can be achieve using a disconnected table with the options and a switch function.

This solution is based on a table of sales and using two different columns from different tables but you need to create a table that merges the two values from the columns you need in my case I did it by dax but you can also do it on the query editor.

DinamicAxis - RegionChannel = 
   FILTER( UNION(
        ADDCOLUMNS(SELECTCOLUMNS(SUMMARIZE(Geography, Geography[ContinentName]),"Region/Channel",Geography[ContinentName]),"Attribute", "Continent"),
        ADDCOLUMNS(SELECTCOLUMNS('Channel',"Region/Channel",Channel[ChannelName]),"Attribute", "Channel")
        ),
[Region/Channel] <> BLANK())

Table is the following:

So basically I picked up the information for other two columns with much more information:

Continent:

Channel

Now you just need to create a measure with the following code:

Dinamic Axis Sales = 
SWITCH (
    SELECTEDVALUE ( 'DinamicAxis - RegionChannel'[Attribute] ),
    "Continent",
        SUMX (
            FILTER (
                SUMMARIZE (
                    sales,
                    Geography[ContinentName],
                    "TotalSales", SUM ( Sales[SalesAmount] )
                ),
                Geography[ContinentName]
                    = SELECTEDVALUE ( 'DinamicAxis - RegionChannel'[Region/Channel] )
            ),
            [TotalSales]
        ),
    "Channel",
        SUMX (
            FILTER (
                SUMMARIZE (
                    sales,
                    Channel[ChannelName],
                    "TotalSales", SUM ( Sales[SalesAmount] )
                ),
                Channel[ChannelName]
                    = SELECTEDVALUE ( 'DinamicAxis - RegionChannel'[Region/Channel] )
            ),
            [TotalSales]
        )
)

Now you can use the values on your table in the legend of the lines and on a slicer:

Please check attach PBIX file.