To implement this recipe, perform the following steps:
- Create the following measures:
Days = COUNTROWS('R06_Table')
January Days = COUNTROWS(FILTER('R06_Table',[Month] = "January"))
January Wednesday Days = COUNTROWS(FILTER('R06_Table',[Month] = "January" && [Weekday] = "Wednesday"))
All Days = COUNTROWS(ALL('R06_Table'))
Weekday Days = CALCULATE(COUNTROWS('R06_Table'), ALLEXCEPT('R06_Table','R06_Table'[Weekday]))
All Years January Days = CALCULATE([January Days],REMOVEFILTERS('R06_Table'[Year]))
January Days? =
CALCULATE(
CALCULATE(
COUNTROWS('R06_Table'),
'R06_Table'[Month] = "January"
) ,
'R06_Table'[Month] = "February"
)
January Days! =
CALCULATE(
CALCULATE(
COUNTROWS('R06_Table'),
KEEPFILTERS(
'R06_Table'[Month] = "January"
|| 'R06_Table'[Month] = "February"
)
) ,
'R06_Table'[Month] = "January"
|| 'R06_Table'[Month] = "March"
)
- Place each of these measures in a Card visualization on a page.
-
Add three slicers to this page for the Year, Month, and Weekday columns from the R06_Table table.