count of free weekends

[Fiala]

Hi, I have a table like this:

I need to count a number of free weekends. The correct result should be 2. 

Can you please help me? Thank you.

[AlB · Accepted solution]

Hi @Fiala 

Try creating a measure as below. Note it is relatively complex; it would be simpler to add some columns to the table you have to simplify it.See it all at work in the attached file.

Weekends_Off = 
VAR auxT_ =
    GROUPBY (
        ADDCOLUMNS (
            CALCULATETABLE (
                DISTINCT ( Table1[Date] ),
                Table1[Workday] = "Weekend",
                Table1[Shift] = "Dayoff"
            ),
            "@WeekNum", WEEKNUM ( [Date], 2 ) & "_" & YEAR( [Date] )
        ),
        [@WeekNum],
        "@Res", COUNTX ( CURRENTGROUP (), 1 )
    )
RETURN
    COUNTROWS ( FILTER ( auxT_, [@Res] = 2 ) )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.