Forum Discussion

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...

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.

Icon for Community Champion rank

Community Champion

7 years ago

If I understand this correctly, I think you want my Inverse Aggregator Quick Measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266

Anonymous
Not applicable
7 years ago
Here I am trying to display all the IDs that are not present instead of sum!

so ouput we be something like

ID
4
5
7
8
9
- Greg_Deckler
  Community Champion
  7 years ago
  It's really pretty much the same thing:
  
  Measure 14 = VAR __ids = SELECTCOLUMNS('Table19',"__id",[ID]) VAR __allIds = ALL('Table18'[ID]) VAR __otherIds = EXCEPT(__allIds,__ids) RETURN CONCATENATEX(__otherIds,[ID],", ")
  
  See Page 6, Tables 18 and 19.
  Working44.pbix310 KB
  - Anonymous
    Not applicable
    7 years ago
    Greg_Deckler Thanks a lot for this,
    
    But What I really want is output as table, As I would Have 1000's of Id and I would like to link those ID's to other table and extract some other information.
    
    I tried Figuring it out! But Can't get it to work.
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