Forum Discussion

Arooz's avatar
Arooz
New Member
6 years ago
Solved

Measure returns true if all rows contain the same value

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 ...
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    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     🙂

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
Arooz
New Member
6 years ago

Worked like a charm, thanks!