Filter context

[BLM]

hi!!

I have many problems with the filters in Dax, I woul like found some tutorial about It....

I want a Measure, "Numero de Cargas", affected by the slicers "año" y "mes" but Not by "1R-Cargado Por". 

This is the formula:

NumCargas = CALCULATE(DISTINCTCOUNT(Cargas[carID]);ALLSELECTED(Cargas[1R-Cargado Por]))

but don't work.

I attache a image

Too, I have created a column, :

Column = CALCULATE(DISTINCTCOUNT(Cargas[carID]);ALLEXCEPT(Cargas;Cargas[1R-Cargado Por]))

but the result it worst...

Help me, please

[v-jiascu-msft · Accepted solution]

Hi @BLM,

You need to clean the filter in the formula by "ALL", "Allexcept" etc. It could be like this:

NumCargas =
CALCULATE (
    DISTINCTCOUNT ( Cargas[carID] );
    ALL ( Cargas[1R-Cargado Por] )
)

If this doesn't work, please provide your data model. A dummy one is enough.

Best Regards,

Dale