topic Re: Keep Filter on Dax Measure and Allowing Other Slicers at the Same Time in DAX Commands and Tips

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

tucahernandes — Thu, 26 Sep 2024 13:29:37 GMT

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

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

DataInsights — Thu, 26 Sep 2024 13:45:18 GMT

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

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

tucahernandes — Thu, 26 Sep 2024 14:30:30 GMT

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

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

DataInsights — Thu, 26 Sep 2024 18:52:55 GMT

tucahernandes,

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