Forum Discussion
AlejandroPCar
8 years agoHelper IV
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, 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
you are giving column name in ALLSELECTED whereas it need to be only Table Name
ALLSELECTED( 'Tabla Cruce')
11 Replies
- parry2kSuper User
Try using ALLSELECTED(TableName)
- AlejandroPCarHelper IV
Hi parry2k
That does not works.
- parry2kSuper User
i just tested at your pbix and it worked
can you share what changed you made to your measure