External filters does not affect ALLEXCEPT

[AlejandroPCar]

Hi, 

I have a measure with ALLEXCEPT that allows me count the number of companies in a sector.  In the first table there are 18 companies in that sector so the count works. But in the same sector, when I filter by city, the count still takes the whole sector. The result must be 2. How can I solve that?

Hope you can help me. Here is my pbix file: https://1drv.ms/u/s!AtTnrgPUQzQCt342k1topoW817Qo

Have a nice day, 

Alejandro

[parry2k]

Try using ALLSELECTED(TableName)

[AlejandroPCar]

Hi @parry2k

That does not works. 

[parry2k]

i just tested at your pbix and it worked

can you share what changed you made to your measure

[AlejandroPCar]

Hi @parry2k

Where exactly did you the change? I replace all the ALLEXCEPT in the masure with ALLSELECTED but the result is this: 

 But I need the total ( i.e. 18 ) for every row. Thats your result too? 

[parry2k]

can you share your measure

it has to be allselected(tablename), not any column in it.

[AlejandroPCar]

Hi, @parry2k 

Here is it 

MEASURE TEST = 
	VAR ClaseS = CALCULATE( [Número de Empresas], ALLSELECTED( 'Tabla Cruce'[CIIUEmpresa] ) )
	VAR GrupoSu = CALCULATE( [Número de Empresas], ALLSELECTED( 'Tabla Cruce'[GRUPOEmpresa] ) )
	VAR DivisionS = CALCULATE( [Número de Empresas], ALLSELECTED( 'Tabla Cruce'[DIVISIONEmpresa] ) )
	VAR SeccionS = CALCULATE( [Número de Empresas], ALLSELECTED( 'Tabla Cruce'[SECCIONEmpresa] ) )
RETURN
	IF( [Número de Empresas] = 0, BLANK(), SWITCH( TRUE, 
					SUM( 'Tabla Sectores'[id_Sector] ) = 1, ClaseS,
					SUM ('Tabla Sectores'[id_Sector] ) = 2, GrupoSu, 
					SUM ('Tabla Sectores'[id_Sector] ) = 3, DivisionS,
					SUM ('Tabla Sectores'[id_Sector] ) = 4, SeccionS ) )

[AlejandroPCar]

Hi , @parry2k

Oh, you are right but... the problem and the important of the allexcept is when I filter with "Nivel Sector" Slicer. And thats my original measure does. Your solution works but cannot filter by "Nivel Sector" anymore. Thats I think is why allexcept is important. 

[parry2k]

what is that 2nd measure you are lookign at does

[parry2k]

not sure i followed you that you can fitler by nivel sector, you can filter by nivel sector, this change is only have impact on one measure "Numero Empresas Secor", so not sure what it will not filter. 

sorry man, because of this langugage challenge, having bit hard time to understand the request.

[AlejandroPCar]

@parry2k

Wow... maybe your solution could be better than I expected in a first time. Amm, sorry about the hard time but yes your are right. Thank you very very much. Hope also you cna help me in my other post of ranking. 

Again Thank you. 

[parry2k · Accepted solution]

you are giving column name in ALLSELECTED whereas it need to be only Table Name

ALLSELECTED( 'Tabla Cruce')