Forum Discussion
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 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 |
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 resultThis 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 🙂
2 Replies
- nandukrishnavs
Community Champion
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 resultThis 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 🙂Worked like a charm, thanks!
