Measure returns true if all rows contain the same value

[Arooz]

Hi, 

I would like to add a Column/Measure 'Free Entirely' which is True when the 'Type' is "Free" for all rows with the same 'Name'. 

I am rather new at DAX and have been stuck at this for a while. Thanks in advance!

I.e. if the Time Filter is set between 9 and <10, and the following table is resulted, the 'Free Entirely' column would result in true, for all Name = Name of current row

Time	Name	Type	Free Entirely
9:00:00	John	Free	False
9:15:00	John	Free	False
9:30:00	John	Busy	False
9:45:00	John	Busy	False
9:00:00	Bob	Free	True
9:15:00	Bob	Free	True
9:30:00	Bob	Free	True
9:45:00	Bob	Free	True

[nandukrishnavs · Accepted solution]

@Arooz 

Try this measure.

FreeEntirely =
VAR _selectedName =
    CALCULATE ( SELECTEDVALUE ( 'Table'[Name] ) )
VAR _countName =
    CALCULATE ( COUNT ( 'Table'[Name] ) )
VAR _countNameFree =
    CALCULATE (
        COUNT ( 'Table'[Name] ),
        FILTER ( ALL ( 'Table'[Name] ), 'Table'[Name] = _selectedName ),
        'Table'[Type] = "Free"
    )
VAR result =
    IF ( _countName = _countNameFree, TRUE (), FALSE () )
RETURN
    result

This will not work if you add the Time field into the visual.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[Arooz]

Worked like a charm, thanks!