This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 51%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
I am trying to create a measure that can show weekly aggregate data when sliced/filtered at the day level. More specifically show the same weekly value for each day of the week that is selected. The closest I have gotten is showing that value at the week level but it still slices if you drill to the day level.
Weekly Budget = CALCULATE([Budget],'Fiscal Calendar'[Week Num] = WEEKNUM(TODAY()))
Seems like a minor oversight but everything I try fails at the day.
Thank you for any assistance you can provide.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Besides filtering the week number to that of today, you also need to remove filters (with ALL or REMOVEFILTERS) from any day-grain columns that could be filtered by report users.
Thank you for the response I appreciate the help. Could you provide rough psuedo-code assuming it is a Y-Q-M-W-D calendar table?
CALCULATE (
[Budget],
'Fiscal Calendar'[Week Num] = WEEKNUM ( TODAY () ),
ALL ( 'Fiscal Calendar'[Date], 'Fiscal Calendar'[DayOfWeek], ... )
)
Thank you that got me started. I appreciate the help.
This did exactly what I asked it to do, but not what I needed it to do. I am pulling this calculation into Power BI and it works fine on a Card visual. Any other visual does not seem to recognize the ALL() statement as it filters down for whatever time period is selected. Is there something special that needs to be done for Power BI visuals to understand how to work with the ALL() filters?
The card visual doesn't provide filter context for your measure, while others like tables, matrices, charts, etc. do. Generally speaking, it seems that in the measure you need to remove filters from more columns or even tables than now. For a more specific answer, we will need the DAX of your measure, the relevant part of your data model, a sample of a misbehaving visual, and an explanation of what you need the measure to do.