Forum Discussion
Finding Delta
Hello all I have a table With Columns: ID platform status 1 a active 2 a active 3 a Inactive 4 b active 5 b active 6 b Inactive 7 c active 8 c a...
- Measure =VAR __ids = SELECTCOLUMNS('Table19',"__id",[ID])VAR __allIds = ALL('Table18'[ID])VAR __otherIds = EXCEPT(__allIds,__ids)RETURN IF(SELECTEDVALUE(Table18[ID], 0) IN (__otherIds), 1, 0)The above measure is working as I wanted it to. by setting a visual filter for a table visual. where Measure IS 1Thank you Greg_Deckler and Anonymous for your time.
Measure =
VAR __ids = SELECTCOLUMNS('Table19',"__id",[ID])
VAR __allIds = ALL('Table18'[ID])
VAR __otherIds = EXCEPT(__allIds,__ids)
RETURN IF(SELECTEDVALUE(Table18[ID], 0) IN (__otherIds), 1, 0)
The above measure is working as I wanted it to. by setting a visual filter for a table visual. where Measure IS 1
Thank you Greg_Deckler and Anonymous for your time.