Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    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.
     
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have created a measure that is giving me the count

 

CALCULATE(COUNT(TABLE1[ID]), TABLE1[Status] = 'Active') - DISTINCTCOUNT(TABLE2[ID])

 

 

BUT Instead of Numbers I want to display the actual ID  Greg_Deckler