Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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.
@Anonymous
Try like
Qty = calculate(sum(MarsAgentAvailability[RemainingAvalHrs]),
filter(all(DimFisCal),DimFisCal[DAY]>=today() && DimFisCal[DAY]<=today()+14))
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |