measure and multiple slicer

[ktt777]

Hi , 

 i have my data here: 

How can i get average sale not affected my slicer "type" ? 

I want to calculate the average for status "Active" for different region and country in different month. I don't want the Type slicer is applied to my average in this graph .

My file is here : https://1drv.ms/u/s!ApIDnMK2eKiFgQJr9w9NZ7Hr8fQS?e=fYjt0f

thanks 

[az38]

@ktt777 

try to use option Edit interaction for your type s;licer - https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

deactivate Average sales chart for this slicer

[ktt777]

 is there a way to  do with changing measure ? 

There is still other thing in the same chart that i want the "Type" slicer to be applied .

I want to count number of countries in the month that the sale below the average ?

Number of  countries will be applied filter "Type", but average is not .

and i want these 2 measure are in the same gragh

[V-pazhen-msft]

@ktt777 
Go with this measure:

Average Sale = var numerator = CALCULATE(SUM(Sheet4[Sale ]),FILTER(ALL(Sheet4),Sheet4[Status]="Active"), 
FILTER(ALL(Sheet4),[Period].[Month]=MAX([Period].[Month])))

var denominator = CALCULATE(COUNTROWS(Sheet4),FILTER(ALL(Sheet4),Sheet4[Status]="Active"), 
FILTER(ALL(Sheet4),[Period].[Month]=MAX([Period].[Month])))

return divide (numerator, denominator)

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38 · Accepted solution]

@ktt777 

try

Average Sale = 
var numerator = CALCULATE(SUM(Sheet4[Sale ]),Sheet4[Status]="Active",ALL(Sheet4[Type]))
var denominator = CALCULATE(COUNTROWS(Sheet4),Sheet4[Status]="Active",ALL(Sheet4[Type]))

return 

divide(numerator,denominator)