Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Helper IV
8 years ago
Solved

External filters does not affect ALLEXCEPT

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...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

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

     

    ALLSELECTED( 'Tabla Cruce')
parry2k's avatar
parry2k
Super User
8 years ago

can you share your measure

 

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

AlejandroPCar's avatar
AlejandroPCar
Helper IV
8 years ago

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 ) )

 

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

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

     

    ALLSELECTED( 'Tabla Cruce')
  • AlejandroPCar's avatar
    AlejandroPCar
    Helper IV
    8 years ago

    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's avatar
      parry2k
      Super User
      8 years ago

      what is that 2nd measure you are lookign at does

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        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.