Forum Discussion
Solved
Missing Data in visual Table - Week over Week
The issue is that I am trying to get Week over Week % AND the ability to use Page Filters to affect the totals. First off, just getting the correct sales from last week is giving me problems. By...
ALLSELECTED by definition will not allow you to access periods that are filtered. You need to use ALL. Also, you don't seem to have a calendar table. You should always use a calendar table for time intelligence https://exceleratorbi.com.au/power-bi-calendar-tables/
when you use ALL(calendar[date]), it should work.
ALLSELECTED by definition will not allow you to access periods that are filtered. You need to use ALL. Also, you don't seem to have a calendar table. You should always use a calendar table for time intelligence https://exceleratorbi.com.au/power-bi-calendar-tables/
when you use ALL(calendar[date]), it should work.
After building your Calendar, I'm in business. Thanks Matt!