slicing effect on report

[MHTANK]

DATA:

Report:

Measures:

sale_avg = CALCULATE(AVERAGE(Sheet1[sale_value]), Sheet1[Status]="Sale")

stock_avg = CALCULATE(AVERAGE(Sheet1[stock_Value]), Sheet1[Status]="Stock")

Purpose:

When I filter from slicer I want effect only on sale_avg line not affect stock_avg line data.

[MFelix]

Hi @MHTANK 

Redo the stock average measure to:

stock_avg = CALCULATE(AVERAGE(Sheet1[stock_Value]), Sheet1[Status]="Stock", REMOVEFILTERS(Sheet1[Diff]))

[MHTANK]

By that measure stock line also affect.

[MFelix · Accepted solution]

Hi @MHTANK ,

I apologize for the missleading answer, the question is that since you are using data from the same table you get the data filter on the visualization and there is no option for you to remove it since the context is based on the filtered values from the diff and you cannot change the context passed to the axis individually.

For this create a new table with the months and make a relationship with the sheet1

Now redo your measure to:

stock_avg = 
CALCULATE(AVERAGE(Sheet1[stock_Value]), FILTER(ALL(Sheet1[Status]),Sheet1[Status]="Stock"), REMOVEFILTERS(Sheet1[Diff], Sheet1[Month]))

Please see attach file.