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

  • AlejandroPCar's avatar
    AlejandroPCar
    Helper IV
    8 years ago

    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.