Filter only on one of multiple values in one chart

[HansB]

I created a line chart with two of the same line values (sales). What I would like to achieve, is to show two different values of sales within one line chart: 1. general value (the whole company, unfiltered) 2. value for a specific region (filtered) The specific region should preferably be able to filter by a slicer or level filter. If found no way to achieve this in Power BI. Is this possible? I use a live connection to a cube, so MDX is not possible, but DAX should be possible in the future.

[parry2k · Accepted solution]

THis can be achieved using calculated measures (DAX) since you are using live connection to cube and cannot create calculated measure, only way is to add calculated member in the cube and then use that for 2nd line graph.

So pretty much it all goes back to cube, cannot do much in PowerBI to achieve this.