Use the Year slicer to only choose 2020. The values for the measures become the following:
|
Measure |
Value |
Explanation |
|
Days |
366 |
This measure is being filtered by the Year slicer and 2020 is a leap year. |
|
January Days |
31 |
This measure is being filtered by the Year slicer and January has 31 days. |
|
January Wednesday Days |
5 |
This measure is being filtered by the Year slicer and January 2020 has five Wednesdays. |
|
All Days |
1096 |
The ALL function overrides the filter from the Year slicer, so this is a count of all rows in the table. |
|
Weekday Days |
1096 |
The ALLEXCEPT function overrides the filter from the Year slicer, so this is a count of all rows in the table. |
|
All Years January Days |
