Measure to show/hide a value based on slicer selections(MultipleSelections)

[kkalyanrr]

Hello,

I'm looking for a measure, where in we select continuous months then the measure should work , if we select the months which are not in sequential order measure should show blank value.

For eg: measure shld work when we select Jul and Aug..it shld return zero value when we select Jul and Sep.
I tried using hasonevalue function , but it works with only one month at a time.

[CNENFRNL · Accepted solution]

@kkalyanrr , the logic is a bit verbose to test whether selected items are in a row; you might try this pattern, (assume your Calendar table is like this)

Test Consecutive = 
VAR __mth_selected = COUNTROWS ( ALLSELECTED ( 'Calendar'[Year-Month] ) )
VAR __period = ALLSELECTED ( 'Calendar' )
VAR __mth_min = MONTH ( MINX ( __period, 'Calendar'[Date] ) )
VAR __mth_max = MONTH ( MAXX ( __period, 'Calendar'[Date] ) )
VAR __consecutive = __mth_max - __mth_min + 1 = __mth_selected
RETURN
    IF ( __consecutive, "Consecutive", "Not Consecutive" )