Forum Discussion

Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
2 years ago

Check selected row against Selected values from Slicer

Hi   im trying to a put a 1 against each row where the the current row matrix interval = the slected values in the slicer (multiple selection rather than single value is possible)   ive tried the...
SELECTEDVALUE
Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
2 years ago

Hey i created a disconnected interval table called Time_Disconnected but still get same result (1 against each row)

 

tried to use offset function to get same row but didnt work as it kept saying maybe duplicate values

 

Selected Intervals To Show =

VAR SelectedIntervals =ALLSELECTED(Time_Disconnected[Revised_Time])

VAR IntervalValue = MIN(qry_previous_180_days[Revised_Time])

RETURN

IF(IntervalValue IN SelectedIntervals,1,0)