topic Filtering in DAX Commands and Tips

Filtering

citr10 — Wed, 29 Nov 2023 08:02:58 GMT

Hello. I need help about using two date slicers in one table. I have 2 table. First table include date, product, quantity. Second table include date and id. So I want to show all product and their relevant sum of quantities on matrix table with 2 date selection. But problem is that when I select first date and then second date, it's only shows products selected at first date. I'll appreciate your help. P.S. Screenshots atached.

Re: Filtering

Dangar332 — Wed, 29 Nov 2023 08:12:27 GMT

HI, citr10

use edit interaction feature refer HERE

use edit interaction bw your both slicer so not interact with each other

Re: Filtering

citr10 — Wed, 29 Nov 2023 08:19:18 GMT

I already did it. I think problem is in measures.

Re: Filtering

ray_codex — Wed, 29 Nov 2023 08:26:07 GMT

Maybe a open door, but why are you trying to do this and not using one date table with one date slicer?

Re: Filtering

Dangar332 — Wed, 29 Nov 2023 08:26:21 GMT

hi, citr10
try to remove ALL() function from both measure

use only sum(product[quantity])