Ignore page date filter, allow matrix with rows of different set of dates.

[Anonymous]

Hi everyone!

I have a page filter filtering dates for the prior 12 calandar weeks on my date table, but i also have a matrix visual that looks 14 days forward, so i'd like to ignore this page filter AND allow the future 14 days to show in this matrix, so it would look like the following:

Date	Qty
3/16/2020	1
3/17/2020	2
3/18/2020	12
3/19/2020	4
3/20/2020	5
3/21/2020	85
3/22/2020	45
3/23/2020	6
3/24/2020	24
3/25/2020	7
3/26/2020	12
3/27/2020	19
3/28/2020	20
3/29/2020	30
3/30/2020	40
3/31/2020	15

Right now im using the following measure, but i am currently getting a matrix with no rows.

Qty = calculate(sum(MarsAgentAvailability[RemainingAvalHrs]),filter(DimFisCal,DimFisCal[DAY]>=today() && DimFisCal[DAY]<=today()+14),all(DimFisCal[DAY]))

Is there any way i could modify this measure to allow the 14 days to show?

Thanks!

[v-yuta-msft]

@Anonymous ,

Could you please share the complete sample data? For example, the [RemainingAvalHrs] and [DAY] columns.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous 

Try like

Qty = calculate(sum(MarsAgentAvailability[RemainingAvalHrs]),
filter(all(DimFisCal),DimFisCal[DAY]>=today() && DimFisCal[DAY]<=today()+14))

[Anonymous]

@amitchandak Hi! Thanks for your reply!
While this option did give me rows, it doesnt seem like it understands to filter in the context of date within the matrix anymore, as it just gives me the same value for each date.