All function is not ignoring slicer in measure

[Anonymous]

Hi Everyone,

I want to ignore a 'name' slicer in measure. I have a table with multiple columns. I want to filter the data with the manufacturer and model, it is working properly but when I select 'name' Slicer, the value again changes. I wanted to ignore the 'name' slicer.

measure: calculate(average(sales), All(Table(name)))

Table:

manufacturer	model	name	sales
GEI	ICSC	A	10
GEI	adss	B	20
GEI	ssd	C	30
Client	ICSC	A	20
Client	adss	D	40
Client	ssd	E	30
Client	ICSC	C	20
Client	adss	G	10
Customer	ssd	D	40
Customer	ICSC	E	30
Customer	adss	F	50

Can anyone help me know what I'm doing wrong in ignoring that slicer? Any help is appreciated.

Thanks

[Greg_Deckler]

I whipped up this quick PBIX. Seems to work for me that the measure is not impacted by a Name slicer, see attached PBIX file.

[amitchandak]

You can switch of the interaction between visual and name slicer

[Anonymous]

Thanks, but I want to select those names.

[v-shex-msft]

Hi @Anonymous,

I'd like to suggest you use allexcept function to define which fields can interact with calculations formulas:

Using ALLEXCEPT versus ALL and VALUES 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

I'll look, but you are taking an average of a text field?

[Anonymous]

By mistake, I used the name on average, but it's the sales field on average.

measure: calculate(average(sales),All(table(name)))

[Anonymous]

Try to use filter first with manufacturer and model slicer, then try with name slicer. Then it will change.