I have a line graph which is supposed to show Net Order Value development over the whole year, even when in my Year/Month Slicer only one Month is selected from a specific year.
E.g. Select Jan & Feb from 2021 => only 2021 Net Order Value Data (the whole year) should be displayed in the Line Graph.
The Year/Month slicer contains a Year column and Month (Jan, Feb ...) column.
Is there a way to create a Dax Measure which can calculate Net Order Value
Net Order Value =
SUMX('Order','Order'[Order Value]-'Order'[Credit Note Value])
so that it calculates the value for the whole year based on the month selection in the Year/Month slicer?