Keep Filter on Dax Measure and Allowing Other Slicers at the Same Time

[tucahernandes]

I need a measure which at the same time, when I select na owner of a store (field franqueado), it brings me the all amount of the region involved (field região).

If for instance, I select the owner "Peter" and he is from South region, the same should bring me the all amount of the South region

That's ok so far, I've made it with the measure below:

CALCULATE (
[Qtd Vendida],
ALL(vw_pbicompras_lojas),
KEEPFILTERS ( vw_pbicompras_lojas[regiao] IN VALUES ( vw_pbicompras_lojas[regiao] )
))

The problem: the same measure should also consider the selection of the field clube presented on the same table. And this doesn't happen currently, because of the All on the measure.

What are the needed adjustments on the measure above, so that it could consider the slicers selections of the field clube?

dssgasg

[DataInsights]

@tucahernandes,

You can replace ALL with ALLSELECTED to keep external filters (e.g., slicers).

CALCULATE (
    [Qtd Vendida],
    ALLSELECTED ( vw_pbicompras_lojas ),
    KEEPFILTERS ( VALUES ( vw_pbicompras_lojas[regiao] ) )
)

[tucahernandes]

Hi, 

It didn't work. With your measure, when I select "franqueado" on slicer, it brings me only the franqueado's value. And I need the all amount of the related region (field "região).

[DataInsights]

@tucahernandes,

Would you be able to provide sample data or a pbix link (OneDrive, etc.)?